2nd lowest number in an array
Greg,
Use a second Array, with formulas like this to remove duplicates:
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")
(copied down to match your first array), then do the SMALL on the second array.
HTH,
Bernie
MS Excel MVP
"Greg" wrote in message
...
I have a simple array, just 1 column.
But various numbers are listed multiple times.
using =SMALL(ARRAY,2) or =SMALL(ARRAY,3) or =SMALL(ARRAY,4)
all yield the same number.
Obviously =SMALL will yield the 2nd number as in a sequence of all numbers
in the array, it does not yield the 2nd Smallest or Lowest number.
|