I have a colum with id's and I want to count how many times each id is repeated in this colum.
How can I do this and paste the answer into a seperate sheet?
Thanks!
I have a colum with id's and I want to count how many times each id is repeated in this colum.
How can I do this and paste the answer into a seperate sheet?
Thanks!
Take a look at the help on COUNTIF function. Paste it next to a list of unique ID's and it should do the job for you.
I took a look at the help on the countif function and I am still confused. Am I looking for anything specific?
Have a look at the examples here:
http://www.excelfunctions.net/ExcelCountif.html
and
http://office.microsoft.com/en-us/ex...in=HP010079186
If you have trouble implementing then specify what ranges, columns, sheet names you're using (or attach a sample) and we'll provide specific help.
Number | Name
So I have two colums, Name and number. I want a formula that will check if any numbers are repeated and count how many times they are repeated. Is this possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks