Forum Discussion
Solved
Tracking Highest Revisions with Duplicated Titles
I'm looking to track the highest revision for a transmittal / document log. Each revision of the file title received is entered in it's own row - If "Structural Drawing 1" (col. A) has seven revisi...
In C3:
=LET(Title, A3:A13, Version, B3:B13, IF(Version=MAXIFS(Version, Title, Title), "IFC", "Old"))
Adjust the ranges as needed. See the attached demo workbook.
In C3:
=LET(Title, A3:A13, Version, B3:B13, IF(Version=MAXIFS(Version, Title, Title), "IFC", "Old"))
Adjust the ranges as needed. See the attached demo workbook.
Thank you Hans!!!