Hello and thank you for this opportunity to ask a question.
On my sheet in column B i need to identify any numbers that have 5 or more duplicates. I am familiar with the COUNTIF formula but I just cant get this to recognize.
formula tried: =COUNTIF($B$2:$B$2000,B2)>5
Thanks for your support
Hi, welcome to the forum
Try this in CF...
=COUNTIF($A$1:$A$15,A1)>5
Last edited by FDibbins; 02-03-2015 at 02:17 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for the reply. It did nothing. I'm trying to identify these in column B and at one point it was working it would just add the cell above it. for example it would highlight 5,6,6,6,6,6, or 11,12,12,12,12,12.
It worked when I tried it. Upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Select column B and use this formula in Conditional formatting
=COUNTIF(B$2:B$2000,B2)>5
It will highlight names that occurred more than 5 times
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
OK, so maybe I got my ranges off, I only just noticed you said column B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks