I'm trying to find a way to use a formula or macro that would sort through a column of approximately 10,000 license plate # (alpha and numeric) starting in cell A2 through A10001 and return any License Plate # that appeared 5 or more times by listing the License Plate # in say Column D and the number of times it appeared in Column E.
Any help would be greatly appreciated.
Hi, welcome to the forum
It's easier to offer help if you provide a sample workbook, but assuming your data looks something like column A below...
aa123 aa123 aa123 aa124 aa124 aa124 aa125 aa125 aa125 ba126 aa123 aa123 aa124 aa124 aa125 aa125 ca126 aa123 aa123 aa124 aa124 aa125 aa125 ca126 aa123 aa123 aa124 aa124 aa125 aa125 ea126 aa123 aa123 aa124 aa124 aa125 aa125 aa126
B is a helper column with this, copied down...
=IF(COUNTIF($A$2:$A$21,A2)>4,A2,"")
You can hide this if needed
For pulling in the data
C2=IFERROR(INDEX($B$2:$B$21,MATCH(0,INDEX(COUNTIF($C$1:C1,$B$2:$B$21),0,0),0)),"")
D2=IF(C2="","",COUNTIF($A$2:$A$21,C2))
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
Thanks for the tip Ford...haven't been on here in some time and sent the post on the fly! We'll give it a shot...and thanks very much for the reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks