Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER
Hello: In my spreadsheet I have many members that i am designing. each member has a name that starts with a "J". For example J1, J2, J3....... i might do several checks on each member, therfore the marks will be placed in one of the sheets named "QDSsheet" starting in cell "A3" as follows: I wont know how many checks per mark. meaning i might have 4 J1's 0R 100 J1's, and the same goes for other marks. right now my code is set up ok using "FOR... NEXT" provided the marks are in numeric sequential order( J1....., J2.....,J3,.....,J4,.....,it will recognize how many J1 is there or how many J2 is there so it loops by increment of one. I would like you to tell me how to write the code so that it loops through all the marks regardless of the order and what the number or string after the J as shown below. Thanks! Marks J1 J1 J1 J1 J10 J10 J11 J12 J12A J18 J18 J18 J17A J17A J17A J17B J15C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge text in sequential order | Excel Discussion (Misc queries) | |||
Creating a list in sequential order | Excel Worksheet Functions | |||
Countif data is not all in sequential order | Excel Discussion (Misc queries) | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
Sequential looping | Excel Programming |