firstlovecity
New Member
- Joined
- Sep 8, 2015
- Messages
- 1
I have uploaded what my current sheet look like and what is my goal.
-Sheets are categorized by Road ID and are ordered increasingly.
- Every row is identified by Road ID, Start meter and End Meter
- Each row indicates data (Road Id, Start,End,Lane,Speed,Event 1 and more which I trimmed at this stage) for 10 meter section of Road ID from Start to End
My goal is categorize all consequent 10 meter data for Same Road Id.
Example:
Road Id 2011 start from 390 end 400 then Next row it continues from 400 to 410, then 410 to 420 and last is 420 to 430
I want these 4 rows which are consequent be categorized as 2011-A and next two rows which start from 1480 end 1490, then 1490 to 1500 categorized as
2011-B
I tried to solve with without VBA coding and sets of nested IF,conditional formatting however its still not my desire goal.
here is link to image if you are not able to see the image here.
http://s18.postimg.org/6r1ylfnqh/Excell_QA.jpg
appreciate for your help and guidance in advance
-Sheets are categorized by Road ID and are ordered increasingly.
- Every row is identified by Road ID, Start meter and End Meter
- Each row indicates data (Road Id, Start,End,Lane,Speed,Event 1 and more which I trimmed at this stage) for 10 meter section of Road ID from Start to End
My goal is categorize all consequent 10 meter data for Same Road Id.
Example:
Road Id 2011 start from 390 end 400 then Next row it continues from 400 to 410, then 410 to 420 and last is 420 to 430
I want these 4 rows which are consequent be categorized as 2011-A and next two rows which start from 1480 end 1490, then 1490 to 1500 categorized as
2011-B
I tried to solve with without VBA coding and sets of nested IF,conditional formatting however its still not my desire goal.
here is link to image if you are not able to see the image here.
http://s18.postimg.org/6r1ylfnqh/Excell_QA.jpg
appreciate for your help and guidance in advance
![Excell_QA.jpg](/board/proxy.php?image=http%3A%2F%2Fs18.postimg.org%2F6r1ylfnqh%2FExcell_QA.jpg&hash=26e8939b27c1d163a26105b2648a3bfc)