Identify accounts repeated more than 3 times

I see, thank you for changing. I can attempt to make one and upload tomorrow. I did try the conditional formating but would only highlight duplicates which all accounts are repeated at least twice. I did not try the COUNTIF. I will try that. I think that is exactly what I need.

Once I've tried and it works.... what should I use to identify those that are highlighted if the last created date is greater or equal to the previous created date?

Originally Posted by FDibbins

Hi, welcome to the forum

I understand that your file contains sensitive data, so can you mock up a dummy file?

Im thinking that you could use Conditional Formatting with COUNTIF() to highlight the accounts repeated more than 3 times

(forum rules require that your thread title describes what you problem is, so I will change it for you - this time :0 )

Also... what do i put into the () for the COUNTIF for it to identify accounts showing 3 or more times?

Originally Posted by FDibbins

Something like this

=countif(range, cell) >3

That worked. Thank you!