CODEWITHSUNDEEP
google-sheetsfilter
Alon Hamzani
Alon Hamzani

Reputation: 11

Filer in filter (vertical and horizontal) in google sheet

I have a table where the column headers are dates and the row key are letters. the table cells contain values between 1 to 9.

I wish to return a list of the letters based on a date and a value threshold.

f.e. return a list of letters where date=X and (on that day) the values are above 5)

I have attached an editable spreadsheet below (https://docs.google.com/spreadsheets/d/1oW7mo3az3a_4dTCEtKauF1qVPEDKb8ydaCLFiHcaWfI/edit?usp=sharing)

Upvotes: 1

Views: 285

Answers (1)

basic
basic

Reputation: 11968

You can use:

=FILTER(B3:B24,INDEX(B3:G24,0,MATCH(J3,B2:G2,0))>K3)

enter image description here

Upvotes: 1

Related Questions