Formula to create ID number based on adjacent column

[carlito2002wgn]

I am looking for the simplest way to create unique ID numbers for tasks. Here is what I have:

Column B contains a list of tasks such as TMF setup, TMF maintenance, Initial Country-Specific ICF Development, CDP Collection and Review
In column A, I want a formula that will number each of the tasks in column B, but if the same task repeats multiple times, I want the ID number to be the same for those repeated tasks.

For example:

1| TMF setup
2| TMF Maintenance
3| Initial Country-Specific ICF Development
3| Initial Country-Specific ICF Development
3| Initial Country-Specific ICF Development
4| CDP Collection and Review
4| CDP Collection and Review

Thanks for all help.

[77highland]

Hi,

You can use this (it assumes your 'list of tasks' is within range B2:B12):

=COUNTIF($B$2:$B$12,"<="&B2)

[bebo021999]

Try in A2:

Please Login or Register  to view this content.

Drag down