Hi - Please help. I have about 50,000 different numbers in column A. All the numbers are 1 through 40. I am trying to count how many times number 1 shows up and number 2 shows up, etc... However, I do not want to count number one as showing up in number 11, 21 and 31. I just want to see how many times each number shows up in each cell as its own number.
Thanks.
maybe:
=COUNTIF(A:A,1)
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Yes- Do you ever have excel act crazy on you and when you have a formula in a cell it doesn't even work or gives you a ridiculous number and when you try and change it, it gets worse. Why does it do that? Anyway, yes I tried that formula originally and it gave me a number like 39,000 which I know was wrong because there was only 40,000 cells. Anyway, I kept clearing the cells and your formula works now.
Thanks a million.
Assuming the data is listed from A1 through A5000:
=COUNTIF(A1:A5000,1)
repeat the formula changing the value to 2, 3, 4, etc until finished
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks