Spreadsheet: 787401d1657785782-copy-formula-down-column-with-a-non-sequential-reference-excel-help
Sheet: Results

Making & Moving Customer Wash %
Laundry | Sector | Customer | Wash % | Diff to Sector Average | Diff to Focus Sector Average | Invoice Value (Month) | Pieces in Circulation (Month)
Bedford | Chemicals manufacturing | Basell Polyolefins UK Ltd [NAME] |  |  |  |  | I want to add here, the average pieces in circulation, for the months of April and May. The data needs to be taken from sheet 'Data', cells H5 + I5. A simple average is enough.
 |  | FFM Engineering Services Ltd |  |  |  |  | This forumla then needs to be copied down through each cell below, but obviously this is a different sequence to that in the 'data' sheet
 |  | Lanxess Limited (UK HQ)
 |  | Sun Chemical
 |  | SUN CHEMICAL - TRAFFORD PARK
 |  | Yara UK Ltd
 | Machinery and other equipment manufacturing | 1st Auto Repairs company
 |  | 316 Engineering Ltd
 |  | A. Schulman Newport Ltd
 |  | A.G.H Engineering company
 |  | ACO Building Drainage
 |  | AGD Equipment Limited
 |  | Airbus
 |  | Alloy Fabweld Ltd
 |  | AM Engineering Limited company
 |  | Bailey & Wade Engineering Ltd company
 |  | BAM Construction Ltd
 |  | Barrett Steel Ltd (Shoreham)
 |  | Barrett Steel South West
 |  | Barretts of Aspley Ltd
 |  | Border Engineering
 |  | Brauer Ltd company
 |  | Cabinair Services Ltd (UK HQ)
 |  | Cambridge Precision Limited
 |  | Church Farm Agriculture Ltd
 |  | Circor Hale Hamilton Valves ltd
 |  | Cummins EMEA Holdings Ltd (Daventry)
 |  | CWE DS Smith
 |  | D.R.N. Engineering Ltd
 |  | D&M Motors company
 |  | Dutton Engineering Limited
 |  | Engineering Diamond Group company
 |  | Flare Products Ltd company
 |  | FT Flood
 |  | Gemini Rail Services
 |  | GT Engineering Ltd
 |  | Holfeld Tool & Die Ltd company
 |  | HUCO Engineering company
 |  | Kempston Ltd company
 |  | King Trailers Ltd
 |  | Lall Precision Engineering Ltd company
 |  | Longford Gear Cutting Ltd company
 |  | [NAME] company
 |  | MDS Ltd company
 |  | Merlin Diesel Systems Ltd
 |  | Metal X Limited company
 |  | Multifab Engineering Metals Ltd
 |  | NMT Crane  Hire Ltd company
 |  | PMC Welding & Fabrication Services company
 |  | Powered Access Services Ltd company
 |  | PSL Holdings Limited company
 |  | Qprep Ltd company
 |  | Ro-Fit & Rod Weld company
 |  | Sandwell UK Ltd company
 |  | Senior Aerospace Thermal Engineering
 |  | SH Jenkins Limited
 |  | SJ Clifford & Co Ltd company
 |  | Spindle Services company
 |  | Spirex Metal Products company
 |  | SPX Cooling Technologies Ltd company
 |  | Trenchless Plant Ltd
 |  | Trevor Verity company
 |  | Trident Design & Fabrication company
 |  | Twiflex
 |  | [NAME]
 |  | Universal Lifting Services company
 |  | Van Elle Limited
 |  | Verco Office Furniture company
 |  | Versalift UK Ltd
 |  | W & W Engineers Ltd company
 |  | Wartsila Defence Solutions Ltd
 |  | Warwick Steel Structures company
 |  | Wickman (Coventry) Limited company
 |  | Wolf Systems Ltd company
 |  | Worldwide Recovery Systems Ltd
 |  | [NAME]
 | Metal and metal products manufacturing | 316 Process Fabrications LTD
 |  | ACO Technologies
 |  | Aeromet International Ltd (UK HQ)
 |  | Ampthill Metal Company Ltd
 |  | Arturn Ltd
 |  | Barrett Steel Services Ltd (Dartford)
 |  | D C Norris & Company Ltd
 |  | Goldstar Metal Traders Ltd
 |  | Goodman Steel Services Ltd
 |  | HBE Services Ltd
 |  | Hertfordshire Diamond Products Ltd
 |  | [NAME] (UK) Ltd
 |  | HSM Aero Limited (UK HQ)
 |  | Islebest Ltd
 |  | Leaside Turned Parts Ltd
 |  | Leidos Industrial Engineers Ltd
 |  | Lilleshall Steel Services
 |  | Rebel Strength Ltd
 |  | Recycling Lives Metal and Waste Ltd (UK HQ)
 |  | SDM Fabrication Ltd
 |  | Severn Valves UK limited
 |  | Shelmar Engineering Limited
 |  | Swann Engineering Group Ltd
 |  | Wood Waste Control (Eng) Ltd
 |  | Young & Woods Ltd
 | Repair and installation of machinery and equipment | Airia Compressed Solutions Ltd (WWS)
 |  | M D Spring Autos
 |  | Surrey Fire & Rescue Service
 | Transport and logistics | Andersons Transport Services Ltd
 |  | [NAME] (WWS)
 |  | [NAME]
 | Transport equipment manufacturing | Arlington Fleet Services
 |  | Wartsila Defence Solutions Ltd
 | Wood and paper products manufacturing | Amcor Flexibles (WWS)
 |  | [NAME] (WWS Spalding)
 |  | Coveris Flexibles Boston Lealand Way
 |  | Coveris Flexibles Tenens Way
 |  | Coveris Head Office
 |  | Crown Packaging Manufacturing UK Limited
 |  | Essentra Plc
 |  | Essentra Plc (Worldwide HQ)
 |  | Graphic Packaging International (Bristol) - WWS
 |  | [NAME] UK (UK HQ, Widnes)
 |  | St Clements Press (1988) Limited
 |  | Ultima Displays LTD
 |  | [NAME] UK Ltd company
 |  | VPK - Wellington
 |  | Walstead Bicester Ltd
 |  | Wepa UK Ltd
 | Chemicals manufacturing | [NAME]
 |  | FFM Engineering Services Ltd
 |  | Griflex
 |  | Kommerling UK Ltd
 |  | Lanxess Limited (UK HQ)
 |  | Lanxess Ltd (UK, [NAME])
 |  | Plastic Coatings Ltd
 |  | Sun Chemical
 |  | Venator Greatham Site Fmasks
 |  | Venator Materials (UK HQ)
 |  | Wealdpark Ltd
 |  | Yara UK Ltd
 | Machinery and other equipment manufacturing | A & K Precision Engineering
 |  | AAP Fabrications Services
 |  | Abba Commercials company
 |  | [NAME] company
 |  | ADM Precision Tools Limited
 |  | Aidservice Ltd, [NAME], 10 [NAME] Park Ind Est, company
 |  | Airbus
 |  | Alexander Comley Ltd company
 |  | Alloy Heat Treatment company
 |  | [NAME] company
 |  | API Design & Build
 |  | [NAME] company
 |  | Armstrong Aggregate Limited
 |  | Arnway Ltd company
 |  | Atkinson Trailer Hire company
 |  | B&A Precision Engineering Limited company
 |  | Baker Hughes Ltd  company
 |  | Barrett Steel Ltd/TA Struthers & Carter
 |  | BNW Co (Bakery) Services Ltd company
 |  | Bold Transmission Parts company
 |  | Brookhouse Aerospace Ltd
 |  | Bus Tec
 |  | C Roberts Steel Services
 |  | C&M Engineering company
 |  | Cascade (UK) Ltd
 |  | Catterall & Wood Ltd company
 |  | CDMS Solutions
 |  | Cell Security Ltd company
 |  | Chelburn Precision Ltd company
 |  | Coilco, Unit 23 Hill Park company
 |  | Compact Manufacturing, Unit 2A Central Works company
 |  | CPM Engineering
 |  | Cutlass Fasteners Limited company
 |  | D&R Starters company
 |  | [NAME] company
 |  | [NAME]
 |  | Depot Engineering
 |  | Dynatech Engineering Ltd company
 |  | E Farrington & Co
 |  | Easiflo Fabrications Limited company
 |  | Fabweld Midlands Ltd company
 |  | Ferguson Engineering Northern Ltd company
 |  | Flexicon Ltd company
 |  | Hampson Composites Ltd company
 |  | Hanson Springs Limited company
 |  | [NAME] company
 |  | [NAME] (Nottingham)
 |  | Hilson Filtration Products Ltd
 |  | Hopwood Gear Ltd company
 |  | IMAG Industrial Motors and Gears Ltd
 |  | [NAME] company
 |  | James Troop & Co. Ltd
 |  | Jetchem Systems Ltd company
 |  | Joe Roocroft & Sons Limited company
 |  | JSA Precision Engineering company
 |  | Juniper Aircraft Service Equipment
 |  | [NAME] (Alfreton)
 |  | KTS Wire Ltd
 |  | KV Welding Ltd company
 |  | Liontech company
 |  | LJF Engineering Ltd company
 |  | Lyndhurst Precision Engineering Ltd
 |  | M R Engineering Group company
 |  | M&N Containers Ltd company
 |  | Marathon Belting Ltd company
 |  | MEAD DIAMOND TOOLING LTD
 |  | Midland Tube & fabrications company
 |  | [NAME]
 |  | Mitek Limited company
 |  | MJB Engineering Services
 |  | Momentive Perform.Materials Ltd company
 |  | [NAME]
 |  | NGF Europe Ltd
 |  | NOV Process & Flow Technologies UK Limited
 |  | Oakham Fabrications company
 |  | OWS Engineering & Welding
 |  | Parker Hannifin Oy
 |  | Parkin Plant Services Limited company
 |  | PBS SPINDLE SYSTEMS
 |  | PDM Fabrications company
 |  | Pipework Engineering Services Ltd company
 |  | PPS Commercials Ltd company
 |  | PW & SI Stelling
 |  | Rainford EMC Systems Ltd company
 |  | Remondis
 |  | RMIG (Warrington)
 |  | [NAME] company
 |  | Rotational Engineering
 |  | S&D (Non Ferrous) Limited company
 |  | Serck Services Ltd company
 |  | SMK Engineering (UK) Ltd company
 |  | Spartan UK Ltd company
 |  | SPECIAL FLANGE SERVICES LTD
 |  | Spincraft ETG
 |  | Spincraft ETG Benwell
 |  | Steel Tool Solutions
 |  | [NAME]
 |  | Structural Manufacturing Services company
 |  | Swift & Whitmore Ltd T/A Jowitt Abrasives
 |  | Technical Welding Services (Rochdale) Limited company
 |  | The Angle Ring Company Ltd company
 |  | Tiger Trailers
 |  | Trufab Technologies Ltd
 |  | Tyne Gangway Structures Ltd
 |  | [NAME]
 |  | Vacuum Impregnated Products company
 |  | W Pym + Son Ltd company
 | Metal and metal products manufacturing | AD Metalwork Solutions Ltd
 |  | [NAME]
 |  | Barrett Steel Services TA Newark Steel Ltd
 |  | Barrett Steel Tubes North Ltd
 |  | C & C Baseline
 |  | C W Fletcher & Sons Ltd
 |  | CMT Steel Ltd
 |  | East Riding of Yorkshire Council
 |  | Eviosys
 |  | Hayley Group
 |  | Holden's CVE ltd
 |  | Hydro Aluminium Tibshelf UK Head Office
 |  | [NAME]
 |  | Map Engineers
 |  | MH Fabrication Services
 |  | [NAME]
 |  | Platinum Precision Sheet Metal
 |  | Platinum Stairlifts Ltd
 |  | Prestwick Aircraft Maintenance
 |  | Renforce Manufacturing Ltd
 |  | Stainless Plating Ltd
 |  | Vulcan Metal Fabrication Limited
 | Repair and installation of machinery and equipment | Easylift Materials Handling ltd
 |  | [NAME] (Alfreton)
 | Transport and logistics | Impacta Ltd
 |  | Mellor Plant UK
 |  | NCRC (Head Office)
 |  | PD Ports
 |  | PRD Services
 | Transport equipment manufacturing | Heroux Devtek (RUNCORN)
 |  | Hitachi Rail
 | Wood and paper products manufacturing | AW [NAME] (HQ)
 |  | COVERIS FLEXIBLES UK LIMITED
 |  | Coveris Flexibles UK Ltd Cramlington
 |  | Coveris Hartlepool
 |  | [NAME]
 |  | [NAME]
 |  | Debmat Surfacing Ltd
 |  | Eviosys Aerosols Packaging UK Limited
 |  | Eviosys Aerosols Packaging UK limited (Sutton)
 |  | [NAME] UK (UK HQ, Widnes)
 |  | News UK & Ireland Ltd (Eurocentral WWS)
 |  | Sabre Triad Ltd company
 |  | [NAME]
 |  | Trinity Mirror Printing Saltire Ltd company
 |  | Trinity Mirror Printing Teesside company
 |  | UPM-Kymmene (UK)
 |  | Walki Ltd UK company
 |  | Wipak UK Ltd company
 |  | York Mailing Ltd