I have a row of measurements and need to find the maximum variance. That is the lowest number divided by the largest number. How can i write this as a formula in excel?
Example: 127 111 119 120 126 maximum variance .126
I always have 6 values in the roll and I need to calculate the maximum value for each row and find the maximum number of rows in excel
Solved by T. U. in 21 mins