Forum Discussion
Solved
max value if criteria match
Dear all, I hope you can help me with this. I am trying to generate a spreadsheet that can keep track of fuel consumption. The one responsible for this will enter the information related to mileage...
As variant
=INDEX($C$2:$C$1000,AGGREGATE(14,6,1/($B$2:$B$1000=$B2)*(ROW($B$2:$B$1000)-ROW($B$1)),1))gives
Thank you both so much, it worked.
Really appreciate your quick responses.
Vito
