Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31507

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080219 | 2008-02-19 | 2008 | 2 | 202416 | Laser range meter PD 4 | 1 | 110 | 120085 | 31507
20090320 | 2009-03-20 | 2009 | 3 | 228031 | Cordless rotary hammer TE 7-A DRS | 1 | 264.78 | 133951 | 31507
20090226 | 2009-02-26 | 2009 | 2 | 228673 | Cordless rotary hammer TE 6-A | 1 | 196.44 | 133371 | 31507
20080522 | 2008-05-22 | 2008 | 5 | 233852 | Rotating laser PR 25 | 1 | 880 | 120085 | 31507
20080117 | 2008-01-17 | 2008 | 1 | 236285 | Cordless circular saw WSC 70-A 36 | 1 | 157.05 | 120085 | 31507
20080117 | 2008-01-17 | 2008 | 1 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 86.5 | 120085 | 31507
20080415 | 2008-04-15 | 2008 | 4 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.84 | 120085 | 31507
20080811 | 2008-08-11 | 2008 | 8 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.8799999999999 | 120085 | 31507
20090226 | 2009-02-26 | 2009 | 2 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 82.59 | 133371 | 31507
20090320 | 2009-03-20 | 2009 | 3 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 78.37 | 133951 | 31507
20090226 | 2009-02-26 | 2009 | 2 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 131.759999999999 | 133371 | 31507
20090226 | 2009-02-26 | 2009 | 2 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 131.759999999999 | 133371 | 31507
20080415 | 2008-04-15 | 2008 | 4 | 272828 | Cordl. impact screwdriver SID 144-A | 1 | 90.2999999999999 | 120085 | 31507
20080811 | 2008-08-11 | 2008 | 8 | 272828 | Cordl. impact screwdriver SID 144-A | 1 | 90.1099999999999 | 120085 | 31507
20080415 | 2008-04-15 | 2008 | 4 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.56 | 120085 | 31507
20080415 | 2008-04-15 | 2008 | 4 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.56 | 120085 | 31507
20080811 | 2008-08-11 | 2008 | 8 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.5799999999999 | 120085 | 31507
20080811 | 2008-08-11 | 2008 | 8 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.5799999999999 | 120085 | 31507
20080117 | 2008-01-17 | 2008 | 1 | 274006 | Battery pack B 36 3.3 Li-Ion | 1 | 152.02 | 120085 | 31507
20080117 | 2008-01-17 | 2008 | 1 | 274006 | Battery pack B 36 3.3 Li-Ion | 1 | 152.02 | 120085 | 31507
20090320 | 2009-03-20 | 2009 | 3 | 274006 | Battery pack B 36 3.3 Li-Ion | 1 | 133.94 | 133951 | 31507
20090320 | 2009-03-20 | 2009 | 3 | 274006 | Battery pack B 36 3.3 Li-Ion | 1 | 133.94 | 133951 | 31507
20081118 | 2008-11-18 | 2008 | 11 | 274919 | Diamond coring tool DD 110-D TPS 110V | 1 | 447.13 | 131087 | 31507
20080522 | 2008-05-22 | 2008 | 5 | 282834 | Battery pack PRA 801 | 1 | 88.93 | 120085 | 31507
20090226 | 2009-02-26 | 2009 | 2 | 286124 | Breaker TE 706-AVR 110V TPS | 1 | 663.32 | 133371 | 31507
20090320 | 2009-03-20 | 2009 | 3 | 331452 | Line laser PML 32-R | 1 | 187.25 | 133951 | 31507
20080304 | 2008-03-04 | 2008 | 3 | 340470 | Battery pack SFB 126 | 1 | 55.62 | 120085 | 31507
20080522 | 2008-05-22 | 2008 | 5 | 377457 | Battery charger PUA 80 | 1 | 63.02 | 120085 | 31507
20081010 | 2008-10-10 | 2008 | 10 | 388214 | Laser range meter PD 40 | 2 | 346.5 | 130097 | 31507
20090226 | 2009-02-26 | 2009 | 2 | 402706 | Combihammer [NAME] | 1 | 399 | 133371 | 31507