Forum Discussion
Match max in column for same item
Hi can you pls help how to do this.
Lets say i take item No.1 from col B and want the max from Col J (max of J5 and J6) for that item. I can use max (vlookup) but it seems tedious if there is a lot more data for a given item. Is there a simpler and concise way to do this?
1 Reply
You can use
=IFERROR(MAX(FILTER(J5:J1000, B2:B1000=1)), "")
You can use a cell reference instead of the fixed value 1.
