# Ranking/Sequence Challenge

#### mikebecker

##### Board Regular
I have data that I can't sort and need to determine the chronological sequence for both date and time for every change in "Rte" and "Number". The sequence will increase when "number" changes but will not increase when the previous "number" is the same. Blank or [NULL] values are only possible in the "Time" column and are ignored.

Thank you,
Mike
Book3
ABCDE
1dely_dteNumberRteTimeSequence
203/05/2009276771346307061
303/05/2009276771346307081
403/05/2009704738346308352
503/05/200927927446309293
603/05/2009276327346310264
703/05/2009275467746311455
803/05/200927331246314377
903/05/2009276379046312246
1003/05/2009275984947607021
1103/05/20092771000476[NULL]
1203/05/2009276195147609062
1303/05/2009276195147609183
1403/05/2009277771047610154
1503/05/2009277403476[NULL]
1603/05/2009576005847613576
1703/05/2009576195047613275
1804/10/200927310646307261
1904/10/2009278620446308022
2004/10/200927736846308313
2104/10/2009276895146311146
2204/10/2009277496146309244
2304/10/2009277496146309224
2404/10/2009724004846310135
2504/10/2009277916346314567
Sheet2

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### barry houdini

##### MrExcel MVP
Hello Mike,

I'm not sure I understand the logic, why are E2 and E3 both 1 but E12 and E13 are 2 and 3?

#### mikebecker

##### Board Regular
Good catch. You're right they should both be the same. Thanks.
Book3
ABCDE
1dely_dteNumberRteTimeSequence
203/05/2009276771346307061
303/05/2009276771346307081
403/05/2009704738346308352
503/05/200927927446309293
603/05/2009276327346310264
703/05/2009275467746311455
803/05/200927331246314377
903/05/2009276379046312246
1003/05/2009275984947607021
1103/05/20092771000476[NULL]
1203/05/2009276195147609062
1303/05/2009276195147609182
1403/05/2009277771047610153
1503/05/2009277403476[NULL]
1603/05/2009576005847613575
1703/05/2009576195047613274
1804/10/200927310646307261
1904/10/2009278620446308022
2004/10/200927736846308313
2104/10/2009276895146311146
2204/10/2009277496146309244
2304/10/2009277496146309224
2404/10/2009724004846310135
2504/10/2009277916346314567
Sheet2

#### mikebecker

##### Board Regular
I'm still stumped with this one.

Replies
3
Views
160
Replies
7
Views
531
Replies
1
Views
1K
Replies
3
Views
545
Replies
1
Views
127

1,191,191
Messages
5,985,211
Members
439,947
Latest member
fabiannic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back