Spreadsheet: 817046d1675966428-extract-data-from-rows-above-with-formula-creditmemodummy
Sheet: Sheet1

CURRENT STATE |  |  | IDEAL STATE - UNFILTERED |  |  |  | IDEAL STATE - FILTERED |  |  |  |  | FORMULA
Order/Header | Site/Dollar |  | Order/Header | Site/Dollar | Site |  | Order | Dollar | Site |  |  | Order/Header | Site/Dollar | Site
441 | 42 |  | 441 | 42 | N/A |  | ECOM123 | 15.51 | 42 |  |  | 441 | 42 | ?
ECOM123 | 15.51 |  | ECOM123 | 15.51 | 42 |  | [NAME] | 42.4 | 42 |  |  | ECOM123 | 15.51 | ?
[NAME] | 42.4 |  | [NAME] | 42.4 | 42 |  | ECOM125 | 3 | 42 |  |  | [NAME] | 42.4 | ?
ECOM125 | 3 |  | ECOM125 | 3 | 42 |  | ECOM126 | 3.74 | 42 |  |  | ECOM125 | 3 | ?
ECOM126 | 3.74 |  | ECOM126 | 3.74 | 42 |  | ECOM127 | 4.04 | 42 |  |  | ECOM126 | 3.74 | ?
ECOM127 | 4.04 |  | ECOM127 | 4.04 | 42 |  | ECOM128 | 3.74 | 42 |  |  | ECOM127 | 4.04 | ?
ECOM128 | 3.74 |  | ECOM128 | 3.74 | 42 |  | ECOM129 | 12.74 | 42 |  |  | ECOM128 | 3.74 | ?
ECOM129 | 12.74 |  | ECOM129 | 12.74 | 42 |  | ECOM130 | 2.39 | 42 |  |  | ECOM129 | 12.74 | ?
ECOM130 | 2.39 |  | ECOM130 | 2.39 | 42 |  | ECOM131 | 35.97 | 42 |  |  | ECOM130 | 2.39 | ?
ECOM131 | 35.97 |  | ECOM131 | 35.97 | 42 |  | ECOM132 | 9.74 | 42 |  |  | ECOM131 | 35.97 | ?
ECOM132 | 9.74 |  | ECOM132 | 9.74 | 42 |  | ECOM133 | 4.49 | 42 |  |  | ECOM132 | 9.74 | ?
ECOM133 | 4.49 |  | ECOM133 | 4.49 | 42 |  | ECOM134 | 16.15 | 42 |  |  | ECOM133 | 4.49 | ?
ECOM134 | 16.15 |  | ECOM134 | 16.15 | 42 |  | ECOM135 | 11.71 | 42 |  |  | ECOM134 | 16.15 | ?
ECOM135 | 11.71 |  | ECOM135 | 11.71 | 42 |  | ECOM136 | 8.51 | 42 |  |  | ECOM135 | 11.71 | ?
ECOM136 | 8.51 |  | ECOM136 | 8.51 | 42 |  | ECOM137 | 11.24 | 42 |  |  | ECOM136 | 8.51 | ?
ECOM137 | 11.24 |  | ECOM137 | 11.24 | 42 |  | ECOM138 | 23.98 | 42 |  |  | ECOM137 | 11.24 | ?
ECOM138 | 23.98 |  | ECOM138 | 23.98 | 42 |  | ECOM139 | 0.79 | 42 |  |  | ECOM138 | 23.98 | ?
441 | 42 |  | 441 | 42 | N/A |  | ECOM140 | 12.21 | 42 |  |  | 441 | 42 | ?
ECOM139 | 0.79 |  | ECOM139 | 0.79 | 42 |  | ECOM141 | 3.19 | 42 |  |  | ECOM139 | 0.79 | ?
ECOM140 | 12.21 |  | ECOM140 | 12.21 | 42 |  | CC18283 | 22.49 | 368 |  |  | ECOM140 | 12.21 | ?
ECOM141 | 3.19 |  | ECOM141 | 3.19 | 42 |  | CC18284 | 2.24 | 368 |  |  | ECOM141 | 3.19 | ?
441 | 42 |  | 441 | 42 | N/A |  | CC18285 | 26.24 | 368 |  |  | 441 | 42 | ?
441 | 309 |  | 441 | 309 | N/A |  | ECOM142 | 16.19 | 469 |  |  | 441 | 309 | ?
473 | 368 |  | 473 | 368 | N/A |  | ECOM143 | 22.49 | 469 |  |  | 473 | 368 | ?
CC18283 | 22.49 |  | CC18283 | 22.49 | 368 |  | ECOM144 | 1.49 | 469 |  |  | CC18283 | 22.49 | ?
CC18284 | 2.24 |  | CC18284 | 2.24 | 368 |  | ECOM145 | 26.24 | 469 |  |  | CC18284 | 2.24 | ?
CC18285 | 26.24 |  | CC18285 | 26.24 | 368 |  |  |  |  |  |  | CC18285 | 26.24 | ?
473 | 368 |  | 473 | 368 | N/A |  |  |  |  |  |  | 473 | 368 | ?
130 | 469 |  | 130 | 469 | N/A |  |  |  |  |  |  | 130 | 469 | ?
ECOM142 | 16.19 |  | ECOM142 | 16.19 | 469 |  |  |  |  |  |  | ECOM142 | 16.19 | ?
ECOM143 | 22.49 |  | ECOM143 | 22.49 | 469 |  |  |  |  |  |  | ECOM143 | 22.49 | ?
ECOM144 | 1.49 |  | ECOM144 | 1.49 | 469 |  |  |  |  |  |  | ECOM144 | 1.49 | ?
ECOM145 | 26.24 |  | ECOM145 | 26.24 | 469 |  |  |  |  |  |  | ECOM145 | 26.24 | ?