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

Date of Order | Date of Order | Year of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
 |  |  |  |  |  |  | 15447.24000000001
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
20080206 | 2008-02-06 | 2008 | 2 | 3080284 | 4 1/2" Dry Diamond Corebit | 1 | 161.13 | 122413 | 31510
20080319 | 2008-03-19 | 2008 | 3 | 228673 | Cordless rotary hammer TE 6-A | 1 | 185.93 | 124538 | 31523
20080319 | 2008-03-19 | 2008 | 3 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 77.5499999999999 | 124538 | 31523
20080319 | 2008-03-19 | 2008 | 3 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.59 | 124538 | 31523
20080319 | 2008-03-19 | 2008 | 3 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.59 | 124538 | 31523
20080707 | 2008-07-07 | 2008 | 7 | 218345 | Universal vacuum cleaner [NAME] | 1 | 384.449999999999 | 123617 | 31525
20080811 | 2008-08-11 | 2008 | 8 | 274919 | Diamond coring tool DD 110-D TPS 110V | 1 | 447.18 | 123617 | 31525
20080708 | 2008-07-08 | 2008 | 7 | 305755 | Rotary hammer TE 16-C 110V | 1 | 324.55 | 123617 | 31525
20080707 | 2008-07-07 | 2008 | 7 | 312265 | Slitting machine DC SE20 110V [NAME] | 1 | 637.73 | 123617 | 31525
20080502 | 2008-05-02 | 2008 | 5 | 272627 | Cordl. ham. dr. driver SFH 181-A 3.0 | 1 | 270.44 | 125858 | 31531
20080708 | 2008-07-08 | 2008 | 7 | 228673 | Cordless rotary hammer TE 6-A | 1 | 185.319999999999 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 77.5799999999999 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.83 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.83 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 337043 | Diamond cutter DC 230-S 110V box | 1 | 155.86 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 382573 | Angle grinder DCG 125-S 110V KL box | 1 | 125.95 | 127404 | 31538
20090318 | 2009-03-18 | 2009 | 3 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133896 | 31541
20090318 | 2009-03-18 | 2009 | 3 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133896 | 31541
20090318 | 2009-03-18 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090318 | 2009-03-18 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090324 | 2009-03-24 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090324 | 2009-03-24 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133896 | 31541
20090318 | 2009-03-18 | 2009 | 3 | 303987 | Orbital jig saw WSJ 850-EB 110V | 1 | 183.34 | 133896 | 31541
20090326 | 2009-03-26 | 2009 | 3 | 378441 | Battery charger C 7/24 230V | 1 | 70 | 134080 | 31541
20090324 | 2009-03-24 | 2009 | 3 | 388214 | Laser range meter PD 40 | 1 | 173.25 | 134039 | 31541
20090318 | 2009-03-18 | 2009 | 3 | 402706 | Combihammer [NAME] | 1 | 399 | 133896 | 31541
20080805 | 2008-08-05 | 2008 | 8 | 274295 | Combihammer [NAME] | 1 | 477.75 | 128309 | 31546
20080805 | 2008-08-05 | 2008 | 8 | 375991 | Orbital jig saw WSJ 850-ET 110V | 1 | 174.61 | 128309 | 31546
20080708 | 2008-07-08 | 2008 | 7 | 388214 | Laser range meter PD 40 | 1 | 165 | 127409 | 31546
20081114 | 2008-11-14 | 2008 | 11 | 282834 | Battery pack PRA 801 | 1 | 93.37 | 131000 | 31554
20090108 | 2009-01-08 | 2009 | 1 | 47995 | Diamond cutter DCH 300 110V | 1 | 408.1 | 132070 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133241 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133241 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133241 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133241 | 31561
20090119 | 2009-01-19 | 2009 | 1 | 370101 | Battery pack SFB 185 | 1 | 89.8599999999999 | 132370 | 31561
20090303 | 2009-03-03 | 2009 | 3 | 370101 | Battery pack SFB 185 | 1 | 89.8599999999999 | 133475 | 31561
20090205 | 2009-02-05 | 2009 | 2 | 388214 | Laser range meter PD 40 | 1 | 173.25 | 132841 | 31564
20090403 | 2009-04-03 | 2009 | 4 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 134360 | 31576
20090403 | 2009-04-03 | 2009 | 4 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 134360 | 31576
20090403 | 2009-04-03 | 2009 | 4 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 134360 | 31576
20090403 | 2009-04-03 | 2009 | 4 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 134360 | 31576
20090317 | 2009-03-17 | 2009 | 3 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 402704 | Rotary hammer TE 16-C 110V | 1 | 299 | 133858 | 31579
20081128 | 2008-11-28 | 2008 | 11 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 91.95 | 131367 | 31945
20081128 | 2008-11-28 | 2008 | 11 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.65 | 131367 | 31945
20081128 | 2008-11-28 | 2008 | 11 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.42 | 131367 | 31945
20081128 | 2008-11-28 | 2008 | 11 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.42 | 131367 | 31945
20080225 | 2008-02-25 | 2008 | 2 | 202416 | Laser range meter PD 4 | 1 | 110 | 118949 | 31946
20080919 | 2008-09-19 | 2008 | 9 | 228195 | Battery pack B 36 2.4 NiCd | 2 | 318.6 | 118949 | 31946
20081128 | 2008-11-28 | 2008 | 11 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 101.58 | 131384 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 76.6299999999999 | 132438 | 31946
20080425 | 2008-04-25 | 2008 | 4 | 272627 | Cordl. ham. dr. driver SFH 181-A 3.0 | 1 | 270.44 | 118949 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 272828 | Cordl. impact screwdriver SID 144-A | 1 | 93.28 | 132438 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 52.1499999999999 | 132438 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 52.1499999999999 | 132438 | 31946
20080918 | 2008-09-18 | 2008 | 9 | 370101 | Battery pack SFB 185 | 2 | 179.72 | 118949 | 31946
20090427 | 2009-04-27 | 2009 | 4 | 378450 | Battery charger C 7/36-ACS 230V | 1 | 98.59 | 134794 | 31946
20080603 | 2008-06-03 | 2008 | 6 | 370101 | Battery pack SFB 185 | 1 | 93.37 | 106298 | 31950
20081218 | 2008-12-18 | 2008 | 12 | 378426 | Battery pack B 24/3.0 NiMH | 1 | 112.37 | 131886 | 31950
20090326 | 2009-03-26 | 2009 | 3 | 402706 | Combihammer [NAME] | 1 | 399 | 134128 | 31951
20090217 | 2009-02-17 | 2009 | 2 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133100 | 31981
20090217 | 2009-02-17 | 2009 | 2 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133100 | 31981
20090217 | 2009-02-17 | 2009 | 2 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133100 | 31981
20090217 | 2009-02-17 | 2009 | 2 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133100 | 31981