Sort formula with criteria

Russk68

Well-known Member
Joined
May 1, 2006
Messages
589
Office Version
  1. 365
Platform
  1. MacOS
Hi
I had a similar project that Peter helped me with here. SORT,FILTER help
I tried to adjust the formula to work without sorting in ascending order without success.
Column BI is where the formula is needed. BH:BI (Gray columns) are the pages in my sheet. BF:BG is continuous to row 5000. Each page has an ID# and they can repeat as you can see with ID #4 at the bottom.
My goal is to fill in the pages with fixture #s according to the ID for each sheet. I also need the fixture #s to remain in the current order per ID on each page. I color coded each page to help show the results that I need.
I appreciate you!



MA2ImportV2.11.15.xlsm
BFBGBHBI
2Fixture #IDIDFixture#
310111101
41021102
51031103
62011201
72021202
81072
91082
101092
111102
121112
131122
142092
152102
162112
172122
182152
192162
202172
212182
222193
232203
242213
252223
262133
272143
284013
294023
304033
317113
3271232107
337133108
342274109
352284110
362294111
372234112
382304209
391044210
402244211
412314212
421054215
432254216
442324217
451064218
462264
474044
484054
497144
503014
513024
522034
533034
542044
553044
563054
572054
583064
592064
603074
612074
623084
6320843219
642334220
652344221
662354222
672364213
689014214
699024401
70402
71403
72711
73712
74713
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
944227
95228
96229
97223
98230
99104
100224
101231
102105
103225
104232
105106
106226
107404
108405
109714
110301
111302
112203
113303
114204
115304
116305
117205
118306
119206
120307
121207
122308
123208
124233
1254234
126235
127236
128901
129902
MA2Import
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,214,865
Messages
6,121,988
Members
449,060
Latest member
mtsheetz

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top