Good afternoon All,
I am looking for help with a formula to extract a list from a database based on 2 criteria. My data is on the tab "Database", and list needs to be on the "report sheet" sheet, where I have placed the 2 criteria. Please see attached spreadsheet.
The formula needs to list all identifiers in the database for a particular person where column H in the database is not "Capex" on the report sheet.
An example of this is found in this Chandoo post, but I struggled to make it work on my data: http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/
I have attached the spreadsheet.
Many Thanks
Herbz
Hi Herbert
I have attached a sample for you to see if this is helpful. I have modified some array formulas (I am not good at array formulas but I will give this a try) and hope it works.
The biggest problem I noticed is that the names in your database have a trailing space. This could be the reason why your formulas are not working as you are comparing "Jason" against "Jason " with a space.
I have added a space behind the names in the data validation list but you should actually remove the excess space from your database.
Hope this helps.
Sunny
