I am working with a census. Each employee has an ID number and each person associated with that ID number (employee, spouse, child) is given a unique sequence number. I want to be able to assign a value based on how many different sequence numbers are attached to the EEID number. For example:
EEID SEQ Relation "***"
10001 00 Employee M
10001 01 Spouse F
10001 03 Daughter F
10001 02 Son M
10002 00 Employee F
10003 00 Employee F
10003 01 Spouse M
In this case, I'd like to assign EF to EEID 10001, EE to EEID 10002, ES to EEID 10003. Is there a way to accomplish this with a formula?
Bookmarks