Hi,
I need a formula that will let me know if a specific value repeats more than x times in a column.
See an example attached. Column A has a list of names. some of them repeat. I need a formula that will give me in column B all the names that repeat more than 5 times.
Thanks
You could do this fairly easily with a helper and filters.
Put this in C2 and copy down...
=IF(COUNTIF($A$2:A2,A2)>5,1,"")
Then apply filters and filter on 1
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
Array formula in B2, then dragdown. See attached file.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks