swati kanodia
New Member
- Joined
- Nov 16, 2015
- Messages
- 5
Hi,
I am trying to create a unique ID for agents registered with me using multiple criteria. Please see the table below.
<tbody>
</tbody>
The State and city code are flowing from another sheet (using Index and Match) that i have not reproduced here.
So, i am trying to create a unique ID using the state and city code, like UP0512/01 for the first agent. i would want these to be created automatically since it is a large database. i was able to create the first part i.e. UP0512/ . how do i create the number part automatically?? i am stuck there.
Similarly, the ID for the next agent with the same city and state code should generate automatically like UP0512/02.
Any help would be greatly appreciated. Thanks a lot
I am trying to create a unique ID for agents registered with me using multiple criteria. Please see the table below.
S. No. | Agent ID | Name | City | State | State Code | City Code |
1 | Rahul Kumar | Kanpur | Uttar Pradesh | UP | 0512 | |
2 | Sushil Raj | Kanpur | Uttar Pradesh | UP | 0512 | |
3 | Arihant | Bareily | Uttar Pradesh | UP | 0581 | |
4 | Sahil | Bareily | Uttar Pradesh | UP | 0581 |
<tbody>
</tbody>
The State and city code are flowing from another sheet (using Index and Match) that i have not reproduced here.
So, i am trying to create a unique ID using the state and city code, like UP0512/01 for the first agent. i would want these to be created automatically since it is a large database. i was able to create the first part i.e. UP0512/ . how do i create the number part automatically?? i am stuck there.
Similarly, the ID for the next agent with the same city and state code should generate automatically like UP0512/02.
Any help would be greatly appreciated. Thanks a lot