Continuing my learning Phase, I have attached a workbook which shows companies by their contractual status. i.e. Main Contractor, Supplier etc.
Tab "Store Details" lists sample company registration data
Tab "All Data" lists the audit scores for all companies
Tab "Data by Month" is where I would like to be able to filter data based on the selections made on the worksheet.
I need some help to create an array formula that will populate the company names
and to then lookup the data and populate the scores from the "All Data" tab
I hope the work sheet explains this clearly.