hi all
i have a list of over 12000 address and i need to see if an address is repeated more than 4 times. does any one know if there is a formula that will allow me to do this?
thanks
michael
hi all
i have a list of over 12000 address and i need to see if an address is repeated more than 4 times. does any one know if there is a formula that will allow me to do this?
thanks
michael
Try this one (untested)
=if(countif($b$1:$b$12000,$b1)>4,"Criteria reached","")
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.
Addresses.jpg
You can try using a pivotTable instead.
Check out my gig@ http://www.fiverr.com/s/5syr1l
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks