Counting rows???

[Lockedhart]

I have the following in a spreadsheet:

Column A
6650
8334
2331
6650
6650
2331
6650

I want to create a function that will count Column A but do some sort of
incremental counting. This is the result I would like to achieve:

Column A Column B
6650 1
8334 1
2331 1
6650 2
6650 3
2331 2
6650 4

Please help. I have about 25,00o records and I don't want to do this
manually. I've tried =countif and other things. Please advise.

Thanks.

 

[Gary''s Student]

In B1, put 1. In B2, enter:

=COUNTIF($A$1:A2,A2) and copy down

 

[Lockedhart]

WOW!!! That easy, huh? Thank you. It worked.

 

[Lars-Åke Aspelin]

In B1, put 1. In B2, enter:

=COUNTIF($A$1:A2,A2) and copy down

Or just put

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

in B1 and copy down

Lars-Åke

 

[Lockedhart]

Okay...need to add to it.

My spreadsheet is grouped by Member ID, is there away to copy the formula
so the range is restricted to that Member? For example,

Column A (Member ID) Column B
123 6650
123 8834
123 2331
123 6650
123 6650

456 8834
456 2231
456 2231
456 8834
456 6650

Any ideas?

Thank you.

 

[Lars-Åke Aspelin]

Okay...need to add to it.

My spreadsheet is grouped by Member ID, is there away to copy the formula
so the range is restricted to that Member? For example,

Column A (Member ID) Column B
123 6650
123 8834
123 2331
123 6650
123 6650

456 8834
456 2231
456 2231
456 8834
456 6650

Any ideas?

Thank you.

Try this formula in cell C1 and copy down

=IF(A1="","",SUMPRODUCT((A$1:A1=A1)*(B$1:B1=B1)))

Ready for next additional requirement ;-)

Lars-Åke

 

[Lockedhart]

Very cute Lars-Ake! No more additions to my problem. This is it.

When you have time can you explain this in 'English'?

Thanks.