I'd like to use the SMALL() function in excel to pull out the second lowest unique value in a list, but I'm not sure there is a way to do this.
For example, if the array is {1,1,3,10,2,6}, then SMALL(array,2) returns 1, but I'd like it to return 2.
Is there a way I can modify this function or use a different one to achieve what I want?
Any help would be *greatly* appreciated. Thanks.
Bookmarks