Hi,
Thanks for taking the time to read this thread. I'm trying to create an Excel formula that will take the 2nd occurrence of a value(a duplicate) as the 2nd largest expense and so forth. What I have now is this...

=INDEX($B$6:$B$32,MATCH(LARGE($C$6:$C$32,2),$C$6:$C$32,0))

I think I need to put a countif statement in the formula somewhere to make it rank the 1st expense, 2nd, the 3rd,etc.

The problem with the formula as is...if I have $500 for a 401k expense and $500 for Rent. It will only pick one and not the other.