| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions expertnumbering random condition in a column
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 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 1st red 2 blue 1 1st blue 3 red 2 2nd red 4 red 3 3rd red 5 white 1 1st white 6 blue 2 2nd blue When the order changes I want the spread to adjust accordingly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Help with Random Functions | Excel Worksheet Functions | |||
| Generation of random numbers and sum of those with a condition | Excel Worksheet Functions | |||
| random numbering | Excel Worksheet Functions | |||
Threaded Mode
