Hi Everyone.

I know the question of Match & Large has been answered before, I have seen the threads, but most seem to want to ignore the duplicates, whereas I want to be able to return the position (column) of these data points. The data is organized with dates in column A and then 29 data points across columns B to AD. For example:

1/1/2000 .01 .02 .03 .04 .05 .06 .06 .07 .05 .04, etc

I want to be able to find the 1st, 2nd, and 3rd largest data points and then return their column numbers. If I use Match & Large to find these points on the above data, I can only get it to return column#9 for largest, and then column#7 for both the 2nd and 3rd largest. I want it to return column#9, column#7, and column#8, for first, second & third.

Can anyone help?

thank you.