| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Numbering different products
With your posted data in B5:B10, use this formula in C5 and fill down... =COUNTIF($B$5:B5,B5) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Manos" wrote in message 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Numbering different products
No i do not want this
I need to show in line 3 that red is appeared as twice in line 4 to show that red appeared as third time and show on.... "Jim Cone" wrote: With your posted data in B5:B10, use this formula in C5 and fill down... =COUNTIF($B$5:B5,B5) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Manos" wrote in message 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Numbering different products
That is exactly what it does. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Manos" wrote in message No i do not want this I need to show in line 3 that red is appeared as twice in line 4 to show that red appeared as third time and show on.... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Numbering different products
That is exactly what the formula Jim provided does.
Are you sure that you are using line numbers corresponding to your data range, and are you sure that you've got the right combination of absolute and relative addressing as Jim had? -- David Biddulph "Manos" wrote in message ... No i do not want this I need to show in line 3 that red is appeared as twice in line 4 to show that red appeared as third time and show on.... "Jim Cone" wrote: With your posted data in B5:B10, use this formula in C5 and fill down... =COUNTIF($B$5:B5,B5) "Manos" wrote in message 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. |
| Reply |
| 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 | |||
Linear Mode
