Hi
I have a very large spreadsheet. I need to extract only the records that are duplicated 4 times. I know how to find duplicates but not with the criteria where there must be 4 matches. I know that i can sort the spreadsheet but it is very long and i only need to see those records that are duplicated 4 times. Any helpwould be appreciated.
Thanks,
Maybe like this:
=if(countif($a$1:$a1,a1)=4,4,"")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks