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. ...
Also, what if I had many more columns in he raw data and not just two?
Like the image below.
If you have list of columns to select like this
formula could be
=FILTER(
INDEX(Table1,
SEQUENCE(ROWS(Table1)),
XMATCH( TRANSPOSE($E$3:INDEX($E$3:$E$10,COUNTA($E$3:$E$10))),
Table1[#Headers])),
COUNTIFS($C$3,Table1[CaseName])
)Range E3:E10 is taken with some gap
Jorglo , you are welcome, glad it helped.