Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting and loops
hello i need help with programming a module that will count a column by comparing the value after it and saving the number of rows it counted before a different value occured in addition with saving the row number to a variable at the row right before the different value occured. this will occur throughout the whole column example 245 245 245 245 245 250 250 250 260 260 so the loop (as i would imagine) would count the number of rows for 245 which is 5 and say it occured on row 26 which will save row 26 to some variable then it will count 250 which is 3 and so forth any help would be greatly appreciated -- narutard ------------------------------------------------------------------------ narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111 View this thread: http://www.excelforum.com/showthread...hreadid=387584 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loops... | Excel Discussion (Misc queries) | |||
Do loops | Excel Discussion (Misc queries) | |||
Using For - Next Loops in VB | New Users to Excel | |||
Do Loops | Excel Programming | |||
Do Loops | Excel Programming |