Counting the number of times a number has appeared in a column

[oli35]

Hi,

I want to find and count the number of times a given number has appeared in the same column, based on its position in the column. So if it's the first time it appeared in the column, I want to return 1, if it's the second time it appeared, I want to return 2, etc. I'm thinking of using the formula count, but how do I tell it to "count this number up to this point", since the range is conditional to the position of the number?

An image is worth a thousand words :

Thanks a lot

 

[jasonb75]

Assuming column A

=COUNTIF(A$1:A1,A1)

 

[NeonRedSharpie]

Assuming your data begins in A1:

=COUNTIF($A$1:A1,A1)

I always feel so silly when I post the EXACT thing that the person above me posted. Darned not refreshing.

 

[oli35]

That formula gives me an error. In any case, here is a SS of what I want to do :

https://www.dropbox.com/s/70vkl6g0z8o75td/Screenshot%202014-08-29%2011.48.17.png?dl=1

 

[NeonRedSharpie]

I can't look at your sheet, but what error is it giving?

 

[jasonb75]

I always feel so silly when I post the EXACT thing that the person above me posted. Darned not refreshing.

You can't do that, I've got trademarks and copyrights on that silly feeling, you're stealing my unintellectual property

 

[jasonb75]

See if this works

=COUNTIF(B$4:B4;B4)

 

[oli35]

Well it says the formula is not correct, and it highlights the A1,A1 part. I tried changing the letters to the correct ones, it gives the same error.

 

[oli35]

Great now it works, thanks misters. That's the one that worked in the end: =COUNTIF(A$1:A1,A1)