Hi Guys
I have devised a relational database which is collecting data for specific entities. However specific non-unique attributes gets stored across multiple columns.
How can I use Advanced Filtering to Define a set of criteria that searches for the same attribute across several columns? More specific. The Attribute, MS030 can be present in multiple columns,
But it don't have to be a requirement that it is present in all the columns.
So, if criteria A is present in column A -> copy all rows to "Filter", But if criteria A is also present in Column B -> Copy all rows to "Filter". But if Criteria A is present in both Column A and B, don't copy twice.
I have attached a working sample which I hope illustrates my problem.
When I define the criteria the code assumes the criteria MUST be present in both columns?!
How do I correct this? Should I use another approach then Advanced Filtering..
Best regards
Danny
Bookmarks