Serial nos for unique records

L

Lynne

Hi,
Have a report with the following data

Insurance Patient Name Claim #
EINSURANCE CO. A 123
EINSURANCE CO. A 234
ABC INSURANCE B 245
G INSURANCE C 456
A INSURANCE B 567
EINSURANCE CO. D 678
ABC INSURANCE B 789
ABC INSURANCE B 890
EINSURANCE CO. A 999


What I require is a serial no based on unique patients so the above report should ideally read... is there a formula i can use?

Sr No Insurance Patient Name Claim #
1 EINSURANCE CO. A 123
EINSURANCE CO. A 234
2 ABC INSURANCE B 245
3 G INSURANCE C 456
A INSURANCE B 567
4 EINSURANCE CO. D 678
ABC INSURANCE B 789
ABC INSURANCE B 890
EINSURANCE CO. A 999


Lynne
 
T

Teethless mama

In E2: enter 1
In E3: =IF(COUNTIF($A$2:A3,A3)=1,MAX($E$2,E2)+1,"")
Copy down as far as required
 
L

Lynne

Thanks... that worked well. Just changed the MAX funtion to include a
range.. that may have be a typo error.

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top