Forum Discussion
Get all values from a column based on criteria
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. ...
That could be
=FILTER(INDEX(Table1, SEQUENCE(ROWS(Table1)), IF($E$3="Time", {1,2}, {1,3})), COUNTIFS($C$3,Table1[CaseName]))
Thank you very much! That works as desired.
Just one little detail...
How should I tweak the formula in order to only show the values and not repeat the case name to the left of each number?
Thanks again beforehand!