Ordering instances and numbering them of repeat cases

[hansonrc]

Hi Everyone,

I'm struggling with something that seems rather simple...so simple I can't figure it out.

I have multiple cases (rows) of data for individuals and want to number them so that every case's first instance in the database has a value of 1, every second occurrence, a 2, etc. So I need to lookup the cases by their ID numbers and then lookup the date of each row of data, and on the basis of those two create a new variable that codes the first instance 1, second 2, etc.

Any tips would be greatly appreciated!

 

[Rick Rothstein]

I have multiple cases (rows) of data for individuals and want to number them so that every case's first instance in the database has a value of 1, every second occurrence, a 2, etc. So I need to lookup the cases by their ID numbers and then lookup the date of each row of data, and on the basis of those two create a new variable that codes the first instance 1, second 2, etc.

Assuming your data starts in cell A2, put this formula on Row 2 in whatever column you want your count numbers to be in and copy it down to the end of your data...

=COUNTIF(A$2:A2,A2)

 

[hansonrc]

Assuming your data starts in cell A2, put this formula on Row 2 in whatever column you want your count numbers to be in and copy it down to the end of your data...

=COUNTIF(A$2:A2,A2)

Thank you so much! Worked like a charm.

Many thanks!