| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I number rows based on unique values in another column?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting or Grouping multiple rows based on unique values | Excel Discussion (Misc queries) | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| count number of unique values in column | Excel Worksheet Functions | |||
| How do i count the number of unique values in a given column? | Excel Discussion (Misc queries) | |||
| Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
Threaded Mode
