LinkBack URL
About LinkBacks
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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)
Posting Permissions
Register To Reply
Bookmarks