Forum Discussion
Excel help needed please
I have a column of numbers made up of positive numbers and zeros. Starting from the bottom of the column, I need to find the last 8 non-zero numbers, subtract the two highest and the two lowest numbe...
Just out of curiosity, what does ``subtract the two highest and the two lowest numbers`` mean?!
If the numbers are H1 and H2 (two highest) and L1 and L2 (two lowest), do you mean L1+L2-H1-H2?
(That is, subtract the sum of the two highest from the sum of the two lowest?)
And do you realize that if we "subtract highest from lowest", the result is always negative (or zero only if all the numbers are the same)?
I'd be surprised that that it is your intent, since everything else is positive.