Incremental count

[Adrian Payne]

Hello All
I have a column of numbers in numerical order and what I need is a way to generate an incremental count when there are multiple occurances of the same number.
Please see attached file. Column A is my data and column B is what I require.
Can it be done with formulas?
Many thanks.
Adrian.
Count.xlsx

[Imran Laldin]

Dear,

file could not be attached.

Kindly do as follow:

Type 1 in the first cell
below that cell type the formula =IF(A2=A1,C1+1,1)

Regards,


Imran.

[zbor]

use this in B1:

Please Login or Register  to view this content.

[sourabhg98]

Hello
First put 1 in B1 and in B2 put the following formula

=IF(A2=A1,B1+1,1)
Now copy it below
Tell me if it works right….

Hope it helps

If you are satisfied then just click on ADD REPUTATION below to say thanks.....

Regards
Sourabh Gupta

[Adrian Payne]

Hello All
Great answers, I feel a bit stupid now I see how it's done.
Many thanks.
Adrian.

[zbor]

There is a difference between those two solutions in case of non-contiguous data when previous number (for example 2 on the picture below) appear latter.
In that case mine approuch would keep counting 2's while other solutions will start counting all over again.

It's not that some solution is wrong - it's just what you expect in those situation.

count.jpg

[Adrian Payne]

Thanks Zbor
My data is always in incremental order so not a problem. Interesting to see different solutions though.