II_Evgeniy_II
New Member
- Joined
- Dec 8, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- MacOS
Hey guys, please help me with this thing:
There is a table of customers, where people register not one by one but as a family (2-3 people in a family). Of course, all of them should have id, but this id should relate to the whole family, not to each person individually. So far we just put all the people in our table and manually change the color to people, belonging to one family (of course we put them in order) and then again, manually put the id. Is it possible to put automatic numbering that works in relation to last names. E.g. 3 people with surname Smith have id=1, then as soon as you input another surname, your id changes to 2 (in sequence). I am thinking about IF function here, but I am not sure, how to do that...
There is a table of customers, where people register not one by one but as a family (2-3 people in a family). Of course, all of them should have id, but this id should relate to the whole family, not to each person individually. So far we just put all the people in our table and manually change the color to people, belonging to one family (of course we put them in order) and then again, manually put the id. Is it possible to put automatic numbering that works in relation to last names. E.g. 3 people with surname Smith have id=1, then as soon as you input another surname, your id changes to 2 (in sequence). I am thinking about IF function here, but I am not sure, how to do that...