TheMerchant
Epic Member
- Joined
- Mar 3, 2016
- Messages
- 749
- Reaction score
- 40
- Points
- 3,185
Hi guys, I'm not clued up on excel formulas that can help me figure out my problem, I have a list of about 4000 people, all these people are either main member spouse or child
I need to change the main members to "00", Spouse to "01" and the first child of each main member must be "02" and then if they have a second child it's "03" etc etc
Now with Main and Spouse it's a simple case of Find/Replace
But it becomes tricky with children
Can anyone more experienced please help?
I need to change the main members to "00", Spouse to "01" and the first child of each main member must be "02" and then if they have a second child it's "03" etc etc
Now with Main and Spouse it's a simple case of Find/Replace
But it becomes tricky with children
Can anyone more experienced please help?