kreativsoul
New Member
- Joined
- Jul 21, 2012
- Messages
- 8
[h=2]I have a list of companies that looks something like this:[/h]
Company A
Company A
Company A
Company A
Company B
Company B
Company C
I would like to create a second column that assigns 1 to all instances of Company A, 2 to all instances of Company B and so on..
Is there a formula for something like this:
<tbody>
</tbody>
Company A
Company A
Company A
Company A
Company B
Company B
Company C
I would like to create a second column that assigns 1 to all instances of Company A, 2 to all instances of Company B and so on..
Is there a formula for something like this:
Comapany Name | ID No |
Company A | 1 |
Company A | 1 |
Company A | 1 |
Company B | 2 |
Company B | 2 |
Company C | 3 |
Company C | 3 |
<tbody>
</tbody>