Hi,
Not sure how to formulate this, but i'd like to know how to add numbers (and have it automatically updated) to a column filled with text.
Example:
I have a list like that:
john (1)
ben (2)
pete (3)
henry (4)
and i want to add edouard (3):
john (1)
ben (2)
edouard (3)
pete (3)
henry (4)
How do i do so that the numbers get updated automatically (ie pete (3) -> (4) and henry (5)-> (6))
Secondly, how can i number the cells in the columns (ie (1), (2)) automatically (if i have 150 names to list and numbered like the example above).
For my example, i assume that text+number are in the same cell. Maybe i could have one cell for each value and merge them(just thought about it), but don't if it would work and if practical or not?
Appreciate any helps,
Thanks
Not sure how to formulate this, but i'd like to know how to add numbers (and have it automatically updated) to a column filled with text.
Example:
I have a list like that:
john (1)
ben (2)
pete (3)
henry (4)
and i want to add edouard (3):
john (1)
ben (2)
edouard (3)
pete (3)
henry (4)
How do i do so that the numbers get updated automatically (ie pete (3) -> (4) and henry (5)-> (6))
Secondly, how can i number the cells in the columns (ie (1), (2)) automatically (if i have 150 names to list and numbered like the example above).
For my example, i assume that text+number are in the same cell. Maybe i could have one cell for each value and merge them(just thought about it), but don't if it would work and if practical or not?
Appreciate any helps,
Thanks