Largest discrepancy between two values in one range (index/match/indirect/largest/max)

Try to post a sample workbook with mock-up data at least with your desired results.

Originally Posted by bebo021999

Try to post a sample workbook with mock-up data at least with your desired results.

Done and done. In this example, the function in B8 returns the title "Item 28". The discrepancy between the two values associated with "Item 28" is 1 and 5. I would like the function to work the other way around, so that it returns the title that has the values 5 and 1, in this example corresponding to "Item 18".

Is it understandable?

R

Try this:

Please Login or Register  to view this content.

Replace + by - for vice versa

Note this is array formula, must be confirmed with Ctrl-shift-enter rather than enter only.

Originally Posted by bebo021999

Try this:

Please Login or Register  to view this content.

Replace + by - for vice versa

Note this is array formula, must be confirmed with Ctrl-shift-enter rather than enter only.

Thanks bebo. Unfortunately it does not seem to work. It doesn't locate the biggest discrepancy, rather some arbitrary value/a really small discrepancy. Thoughts?

Update: Nevermind, it seems to work just fine. Thank you.