Hi,
I am having an issue trying to come up with a function to look for the second largest unique value in a column. I know I can use the large function to get the second largest value, but the problem is that there are duplicate values in the column.
For example, I have a range of cells containing, 12,12,12,12,11,10,9,1,0.
The large(a2:a9,2) function will return 12, but I want a return of 11.
Thanks in advance.
Bookmarks