Finding Last Date

[Dummy Excel]

Hi All,
i have 2 columns;
COlumn A is the asset number. The asset number comes up multiple times as we need to do maintenance on our assets
Column B is the date the asset number had its last maintenance completed

if there a formula i can use to highlight to show the last date for that asset number?

thanks
Sam

 

[barry houdini]

By last I assume you mean the latest date. You can try an array formula like this:

=MAX(IF(A$2:A$100=D2,B$2:B$100))

confirmed with CTRL+SHIFT+ENTER

where D2 contains a specific asset number

 

[Tetra201]

If you are talking about conditional formatting, try applying the following CF rule to range, say, B1:B1000

=AND($B1<>"",$B1=MAX(IF($A$1:$A$1000=$A1,$B$1:$B$1000)))

 

[Dummy Excel]

perfect
thanks