Hello all
I am analysing data (see the attached worksheet) that essentially contains two pieces of information:
Sheet 1: shows whether certain reports are relevant for certain companies. A ‘tick’ means that the report is relevant. A ‘dash’ means that the report is not relevant.
Sheet 2: shows the last filing date for each company.
I want to sort the data by the following:
If the report is applicable to the company (represented by a ‘tick’ in Sheet 1), and the date of the report is before the filing date of the company, then I want to extract the data.
I am looking for a solution whereby I can sort by the company and obtain the reports that fit these criteria. For instance, like how you would sort data by using data validation or a pivot table.
Can this be done?
Ideally I would like a solution that would output the results in a clean way (rather than having to copy and paste down formulas like you would with an index/match array function).
Any help would be greatly appreciated.
Thanks in advance.
Bookmarks