I have a spreadsheet which contains a (long) list of names. I need to count how many occurences of each name there are and put that in the next column. The list is already sorted so all of the same names are together.
I have been looking through this site for something but cannot find exactly what I need.
Thanks
All good I just found the answer :-)
Last edited by Ian_X; 11-24-2017 at 01:34 AM.
You can use countif function which is designed for the same.
Have a look at this site https://www.ablebits.com/office-addi...ntif-examples/
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks