| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numbering different products
I need to number random conditions as they occur in a column. The example
show is in its simplest form. Column A is a list of colors that are selected randomly. Column B needs to be the order in which the color code was selected relative to equivalent colors. So the first red selected will be Red-1, next red selected will be Red-2. This will happen to for each color. i.e¦¦¦.. A B 1 red 1 1 2 blue 1 1 3 red 2 2 4 red 3 3 5 white 1 1 6 blue 2 2 When the order changes I want the spread to adjust accordingly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
| Adding Products | Excel Worksheet Functions | |||
| Products | Excel Worksheet Functions | |||
| Sum the products of a formulas | Excel Discussion (Misc queries) | |||
| better/faster way than sum products? | Excel Worksheet Functions | |||
Threaded Mode
