Divakarkumar
New Member
- Joined
- Jul 31, 2020
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
Hi Team,
I have used Maxifs (=MAXIFS($B$2:$B$13,$A$2:$A$13,A2)=B2) to find latest version of quote number(False/ True) but my bad luck the same Maxifs forumal is not available in my Virtual Machine due to excel version issue.
Examples : I have 10 number repeated in A columns 5 times and B column Version like 12345 in the same row and I have to get 4 false and 1 true which is latest one (10 and 5) , I have attached image for better understate.
False : indicate old version
True : Indicate new version
Great if some one provide alternate option to built same logic.