Find which array a value belongs to.

[vhanster]

So, I'm looking for a function that not only returns which is the nth largest value, but which array that value belongs to. Is this possible?

For example, if I have a table that records the sales number from Monday to Friday. I want a formula that gives me which days have the top three sales. Using the =LARGE formula only gives me the sales value, but not what day they're from.

Thank you

[Kaper]

I think that to answer your question, we shall see your data layout.
So follow the yellow banner near the top of the page and attach sample file, please

[vhanster]

Here is the attachment.

[Metoo7]

try this formula:

="D"&MATCH(LARGE($B3:$H3,K$2),$B3:$H3,) &": " & TEXT(LARGE($B3:$H3,K$2),"#,000")

[JohnTopley]

Try


=INDEX($B$2:$H$2,MATCH(LARGE($B3:$H3,K$2),$B3:$H3,0))

[kvsrinivasamurthy]

Pl see file.

In K3

=LARGE($B3:$H3,K$2)

In L3

=INDEX($B$2:$H$2,MATCH(K3,$B3:$H3,0))

copied down both.

Select K3:L6. Use fill handle and drag across.