Hello,
I am a doctor, I am 61 years old.
What algorithm to use to solve Quantitative variables in Excel?
- In row 1, the reference values of the norm, i.e. min/max from the norm
- In row 3, the subtotals. Each person has their own.
- In column A5 and below. The values in the columns are reflected in 100 units, but they can be changed, i.e. you can change 10 units, then divide all the values by columns by 10.
Which rows from 1 to 3 (5435 rows in total) are most suitable if the Data by columns are summed up with the values in row 3 so that the sum is within the norm of row 1?
Sincerely,
Evgeni Mikhailovich