Originally Posted by djferrick

Hi .

I have a list of numbers and a corresponding list of text values

Team Errors
Query Category 7
Query sub cat 8
MSN 1
Exchange date 17
Meter Type 1
Reads 0
Flows 0
MAP ID 3
SSC 3
Mtr type 2
Ecoes date 8

I have been using the below formula to get the top three values and return the corresponding text string in a cell on another part of the worksheet.

=INDEX(W8:X18,MATCH(LARGE(X8:X18,2),X8:X18,0),1)

But as you can see the 2nd largest value has two results. How do I get excel to print one of them and the next time to test wether that string has already been printed and go for the 'other' joint 2nd largest number ?

When I change the LARGE array argument from 2nd largest to 3rd largest number it returns the same string i.e 'Query sub cat' - how can I get it to test wether that string has already been printed and print the string 'Ecoes date' ?

I assume I want to add an AND operator into the above formula something like AND<= the text in cell F30. So look at cell F30 and see what text string is there . If it matches the result from the INDEX formula then print the other string instance of the number / value

thanks for any and all help