In the attached file I want a formula in the highlighted cell that will return the maximum from the Reschedule column based on the match in the Tracking Ref#.
This needs to work no matter the sort applied to the table.
In the attached file I want a formula in the highlighted cell that will return the maximum from the Reschedule column based on the match in the Tracking Ref#.
This needs to work no matter the sort applied to the table.
Try MAXIFS:
=MAXIFS(Table1[Reschedule '#],Table1[Tracking Ref'#],I2)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Only have Excel 2013 in this instance.
Not a problem:
=MAX(IF(Table1[Tracking Ref'#]=I2,Table1[Reschedule '#]))
... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Hi ( Ciao AliGW!)
MAX
=AGGREGATE(14,6,Table1[Reschedule '#]/(Table1[Tracking Ref'#]=I2),1)
Hope that helps
MIN:
=AGGREGATE(15,6,Table1[Reschedule '#]/(Table1[Tracking Ref'#]=I2),1)
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thanks Ali.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks