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.
Structured reference (Tables) (to make it a table select the data and choose Home->Format as Table)
=IF([@Version]=MAX(FILTER( [Version],[Drawing Title]=[@[Drawing Title]])), "IFC", "Old")
or range references
=IF($B$2:$B$100=BYROW($A$2:$A$100,LAMBDA(r, MAX(FILTER( $B$2:$B$100, $A$2:$A$100=r)))), "IFC", "Old")
I didn't have a chance to verify these solutions, but that you m_tarler.