Hi,
I've used filter in the follow formula;
but I would like the array to be dynamic using the match function,Please Login or Register to view this content.
which spills a true or false, and use this instead of the array,Please Login or Register to view this content.
I've used INDEX
with a filter which I've included on second sheet of workbook to show what I'd like to get by using the two filters;Please Login or Register to view this content.
Please Login or Register to view this content.
What am I doing wrong?
Richard.
Bookmarks