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
|