I have a spreadsheet with several items, their volumes and margins. I have no problem in finding the maximum margin with
=MAX(Range). What I need to find is the row number of that value.
Let's say I have these values:
A B C 1 Item1 5m³ 70% 2 Item2 10m³ 80% 3 Item3 2m³ 50%
The maximum margin would be 80%. Now i need to know that this value belongs to Item 2 in Row 2.
Is there a way to find that out?