Add Unique Identifier Based on Record Hierarchy

[jollywood]

Hello,
I have a table with 1.3+ million records. The table houses account numbers (they can exist more than once), a Field_Data_ID field (is incremental and does not repeat...greatest number is most recent addition), a Description field, START_DT and END_DT both in YYYYMMDD format.

My challenge is to find each Field_Data_ID that exists for each unique account number. Once that is done, I need to find where the corresponding START_DT and END_DT overlap or otherwise conflict.

The first part was a simple sort. I want to make an additional column that will say UDF1, UDF2, UDF3, etc. based on the FIELD_DATA_ID hierarchy of each unique account number.

I have no idea where to begin and there are too many records for excel! HELP!...please.

 

[jollywood]

A better way to word it:

For each instance of i, rank the Field_Data_ID among the Field_Data_IDs that have i as an account number.