LinkBack URL
About LinkBacks
Dear`s
The Attached excel file contain 3 column (A = Serial) , (B = Date) , (C = Maximum) , I need to write a formula in C2 to mark one row by "Y" for each unique serial and it has the maximum date.
BR
Dear`s
The Attached excel file contain 3 column (A = Serial) , (B = Date) , (C = Maximum) , I need to write a formula in C2 to mark one row by "Y" for each unique serial and it has the maximum date.
BR
In C2:
=IF(AND(A2=A1,B2=B1),"",IF(MAX(IF($A$2:$A$14=A2,$B$2:$B$14))=B2,"Y",""))
... 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. Once confirmed, drag copy down.
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.
Perfect, this is exactly what I need.
You are the one,
BR
Last edited by AliGW; 04-01-2018 at 12:13 PM. Reason: Unnecessary quotation removed.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks