Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A challenging One
Simplified this but 1st column contains the data and the second column
is emtpy. Below is what I would like the program to produce when run. Basically, For every new series of data a 1 would go in the 2nd column. Pretty easy right, well I also need the program to put a 2 in the second column for every 3rd matching data set after the initial 1. Take a look at the E data, First time it put in a 1, but every 3 matching E's it put in a 2 in the second column. The data and sample of results might explain it better. Challenging I hope for even you experts. Data looks like this Col1 Col2 A A B B B B C D D E E E E E E E E E F F F F G H H H H H Results of Program would look like this Col1 Col2 A 1 A B 1 B B B 2 C 1 D 1 D E 1 E E E 2 E E E 2 E E F 1 F F F 2 G 1 H 1 H H H 2 H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging | Excel Programming | |||
challenging | Excel Programming | |||
Challenging? | Excel Programming | |||
Very challenging | Excel Programming | |||
Something Challenging | Excel Programming |