Checking the latest version of a contract in Excel
First question from stackoverflow, so I hope I did it right! I've looked good on various sites from Mr XL to Chandoo and have looked good here too and I haven't come up with a solution yet.
I have a table that keeps track of contracts, but I need to know if it's the latest version. I have tried the If (Max) formula I have seen suggested to no avail.
This is what I have until it works!
Example:
Contract Number Version - Latest Version
12345 1 =IF(B2=(MAX(A:A=A2,B:B)),"Yes","No")
12345 2
I would like VBA to develop a solution for?
+3
source to share
1 answer
you were close, but not quite, with an array formula introduced with Ctrl+ Shift+ Enter:
=IF(B2=MAX(IF(A2=A:A,B:B)),"Yes","No")
+3
source to share