Hi,
I have a table and I am trying to get ALL values (duplicated or not) from a column in a different sheet based on criteria. The criteria are the highlighted columns in the first image below.
The raw date looks like the other image.
I have came up with the formula below but that only works if I only have 2 different columns in the sheet RAW_DATA:
=FILTER(INDEX(Table1, SEQUENCE(ROWS(Table1)), IF($E$3="Time", {1,2}, {1,3})), COUNTIFS($C$3,Table1[CaseName]))
Many thanks before hand!
I have a table and I am trying to get ALL values (duplicated or not) from a column in a different sheet based on criteria. The criteria are the highlighted columns in the first image below.
The raw date looks like the other image.
I have came up with the formula below but that only works if I only have 2 different columns in the sheet RAW_DATA:
=FILTER(INDEX(Table1, SEQUENCE(ROWS(Table1)), IF($E$3="Time", {1,2}, {1,3})), COUNTIFS($C$3,Table1[CaseName]))
Many thanks before hand!