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!
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 | ||||||
---|---|---|---|---|---|---|
BF | BG | BH | BI | |||
2 | Fixture # | ID | ID | Fixture# | ||
3 | 101 | 1 | 1 | 101 | ||
4 | 102 | 1 | 102 | |||
5 | 103 | 1 | 103 | |||
6 | 201 | 1 | 201 | |||
7 | 202 | 1 | 202 | |||
8 | 107 | 2 | ||||
9 | 108 | 2 | ||||
10 | 109 | 2 | ||||
11 | 110 | 2 | ||||
12 | 111 | 2 | ||||
13 | 112 | 2 | ||||
14 | 209 | 2 | ||||
15 | 210 | 2 | ||||
16 | 211 | 2 | ||||
17 | 212 | 2 | ||||
18 | 215 | 2 | ||||
19 | 216 | 2 | ||||
20 | 217 | 2 | ||||
21 | 218 | 2 | ||||
22 | 219 | 3 | ||||
23 | 220 | 3 | ||||
24 | 221 | 3 | ||||
25 | 222 | 3 | ||||
26 | 213 | 3 | ||||
27 | 214 | 3 | ||||
28 | 401 | 3 | ||||
29 | 402 | 3 | ||||
30 | 403 | 3 | ||||
31 | 711 | 3 | ||||
32 | 712 | 3 | 2 | 107 | ||
33 | 713 | 3 | 108 | |||
34 | 227 | 4 | 109 | |||
35 | 228 | 4 | 110 | |||
36 | 229 | 4 | 111 | |||
37 | 223 | 4 | 112 | |||
38 | 230 | 4 | 209 | |||
39 | 104 | 4 | 210 | |||
40 | 224 | 4 | 211 | |||
41 | 231 | 4 | 212 | |||
42 | 105 | 4 | 215 | |||
43 | 225 | 4 | 216 | |||
44 | 232 | 4 | 217 | |||
45 | 106 | 4 | 218 | |||
46 | 226 | 4 | ||||
47 | 404 | 4 | ||||
48 | 405 | 4 | ||||
49 | 714 | 4 | ||||
50 | 301 | 4 | ||||
51 | 302 | 4 | ||||
52 | 203 | 4 | ||||
53 | 303 | 4 | ||||
54 | 204 | 4 | ||||
55 | 304 | 4 | ||||
56 | 305 | 4 | ||||
57 | 205 | 4 | ||||
58 | 306 | 4 | ||||
59 | 206 | 4 | ||||
60 | 307 | 4 | ||||
61 | 207 | 4 | ||||
62 | 308 | 4 | ||||
63 | 208 | 4 | 3 | 219 | ||
64 | 233 | 4 | 220 | |||
65 | 234 | 4 | 221 | |||
66 | 235 | 4 | 222 | |||
67 | 236 | 4 | 213 | |||
68 | 901 | 4 | 214 | |||
69 | 902 | 4 | 401 | |||
70 | 402 | |||||
71 | 403 | |||||
72 | 711 | |||||
73 | 712 | |||||
74 | 713 | |||||
75 | ||||||
76 | ||||||
77 | ||||||
78 | ||||||
79 | ||||||
80 | ||||||
81 | ||||||
82 | ||||||
83 | ||||||
84 | ||||||
85 | ||||||
86 | ||||||
87 | ||||||
88 | ||||||
89 | ||||||
90 | ||||||
91 | ||||||
92 | ||||||
93 | ||||||
94 | 4 | 227 | ||||
95 | 228 | |||||
96 | 229 | |||||
97 | 223 | |||||
98 | 230 | |||||
99 | 104 | |||||
100 | 224 | |||||
101 | 231 | |||||
102 | 105 | |||||
103 | 225 | |||||
104 | 232 | |||||
105 | 106 | |||||
106 | 226 | |||||
107 | 404 | |||||
108 | 405 | |||||
109 | 714 | |||||
110 | 301 | |||||
111 | 302 | |||||
112 | 203 | |||||
113 | 303 | |||||
114 | 204 | |||||
115 | 304 | |||||
116 | 305 | |||||
117 | 205 | |||||
118 | 306 | |||||
119 | 206 | |||||
120 | 307 | |||||
121 | 207 | |||||
122 | 308 | |||||
123 | 208 | |||||
124 | 233 | |||||
125 | 4 | 234 | ||||
126 | 235 | |||||
127 | 236 | |||||
128 | 901 | |||||
129 | 902 | |||||
MA2Import |