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