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.