Counting Contents

[Mailing]

I have an excel file that has one column of numbers. I need a way to count the number of cells that contain each number. For instance there are 104 cells that contain 001. There are 104 different numbers so anyway to write a formula for one such as 001 and then drag it to make the rest 002 ,003 and so on. Any help would be appreciated. It seems like it should be simple but beyond me.

Thanks, Mike

[SlipEternal]

Suppose column A contains the data you want to count.

In cell B1, enter the formula

Please Login or Register  to view this content.

In cell C1, enter the formula

Please Login or Register  to view this content.

Highlight B1 & C1, drag down to row 104.

[Mailing]

Wow, just shows you the amount of things I don't understand about excel. This works except the first number shows one more than there actually is. The rest of it is perfect. Thank you very much.

[leelnich]

Hi all- here's another way. In B1 and copy down:
=TEXT(ROW(),"000")

[SlipEternal]

Hi all- here's another way. In B1 and copy down:
=TEXT(ROW(),"000")

I thought about that after, but the OP seemed happy with my cumbersome formula, so I left it alone.