I would like to extract rows from one table to another table based on MULTIPLE criteria.
Before going to deep into explanations I will just show you that I managed to do it based on ONE criteria and all I need is to add another criteria:
{=IFERROR(INDEX(Free[Task],SMALL(IF(Free[Cust]=B$1,ROW(Free[Cust])-ROW(Free!C$2)+1),ROWS(Free!C$2:C2))),"")}
In this formula I am taking what's in the column named "Free[Task]" and only IF in the column "Free[Cust]" it matches with what's in the cell C2 then it will extract these values. It works great.
What I need now is to add another IF, that will say IF in column named "Free[V]="V" only then take whats in column named "Free[Task]".
I am trying to avoid uploading the excel, but if necessary I will. Maybe someone can give me a quick solution without it..
Thanks!
Bookmarks