Calculating value less minimum numbers in the sequence
I am trying to find a function that will add a series of numbers LESS the 2
lowest numbers in the seqeunce. They are not in order from lowest to smallest
as there is more than one group and it is sorted by date.
Example:
172 172 172 180 169 180 163 180 175 165 180 175 180
I would need it to pull out the 163 & 165 and add the rest. These numbers
will be different for each row and the lowest are not always in the same
column. Any ideas??
thanks!
Karen
|