Assuming data starts in B2 down
Put in A2: =COUNTIF(B$2:B2,B2)
Copy down. Success? hit the YES below
--
Max
Singapore
---
"Carla" wrote:
I need to create a number in column A based on the data in column B. Here's
an example of the result that I want:

Number Product Code
1 001-1002-P
1 001-1002-R
1 003-4501-10
2 003-4501-10
1 003-4501-12
2 003-4501-12
1 003-4501-14
2 003-4501-14

I'm really looking to get either a 1 or 2 based on the first or 2nd entry of
the product code.
--
Carla