Thread: SMALL and LARGE
View Single Post
  #1   Report Post  
Tonto
 
Posts: n/a
Default SMALL and LARGE

Hello everyone.

I have a column of numbers in an array called TEST

1
1
3
4
5
6
7
7

Why when I run the formula =small(test,2) I get 1 and with
=large(test,2) I get 7.

My logic suggests I should get 3 and 6?

Please help.

Thanks in anticipation.


John