Recent content by davidbaggins

If you're using Excel 365, you can do it with a single formula using `XLOOKUP` and `MAXIFS`: =XLOOKUP(MAXIFS(B:B,A:A,E2),FILTER(B:B,A:A=E2),FILTER(C:C,A:A=E2)) Where: Column A = ID Column B = Date Column C = Value E2 = the ID you're searching for (e.g., A01) `MAXIFS` finds the latest date for...

You can use a simple VBA user-defined function: Function CountFontColor(rng As Range, sample As Range) As Long Dim c As Range For Each c In rng If c.Font.Color = sample.Font.Color Then CountFontColor = CountFontColor + 1 End If Next c End Function