VBA to Find Unique Records

[jwburritt]

Hello: I have a large table where I need to find and then highlight the records that appeared for the first time last month. In case of the sample below, that would be to find records that include Resource C.

Thanks for any ideas!



Date Resource
[TABLE="width: 144"]
<tbody>[TR]
[TD="class: xl64, width: 72"]4-30-19[/TD]
[TD="class: xl65, width: 72"]A[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 72"]4-30-19[/TD]
[TD="class: xl65"]B[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 72"]5-31-19[/TD]
[TD="class: xl65"]A[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 72"]5-31-19[/TD]
[TD="class: xl65"]B[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 72"]6-30-19[/TD]
[TD="class: xl65"]A[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 72"]6-30-19[/TD]
[TD="class: xl65"]B[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 72"]6-30-19[/TD]
[TD="class: xl65"]C[/TD]
[/TR]
</tbody>[/TABLE]

 

[lrobbo314]

How about just adding conditional formatting? Select column B and add '=(COUNTIF($B$1:B1,B1)=1)*(MONTH(A1)=6)' as the formula for the conditional format.

 

[jwburritt]

Thanks. Perfect!