• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filtering a list based on multiple criteria

G

GB

Member
Hi,
I need some assistance with creating a formula to filter a list. In the attached workbook I have
  • unfiltered data in columns A:F
  • in columns I:K is my search criteria
  • in columns N:S are the results of the search
The search criteria requires matching the "Series" from column I & "Level" from column K & "TDTE" from Column J if the "TDTE" <= the value displayed. The result of the query will provide a subset of the data in columns N:S

BTW I watched a this youtube (
) which was helpful when searching for a single row of information but gave no clue for the multiple row scenario that I have.

Any assistance would be appreciated.
regards
GB
 

Attachments

  • Filtering a List Based On Multiple Criteria.xlsx
    17 KB · Views: 7
Hi, Somendra, thanks for your reply but I want to write a formula rather than used the Advanced Filter as my search values will change a lot. No doubt it could be complicated (for me anyway) so any help would be great.

regards
GB
 
In N3 with Ctrl+Shift+Enter copy right and down:

=INDEX(A$3:A$230,SMALL(IF(($B$3:$B$230=TRANSPOSE($I$3:$I$5))*($D$3:$D$230=TRANSPOSE($K$3:$K$5))*($C$3:$C$230<=TRANSPOSE($J$3:$J$5)),ROW($A$3:$A$230)-ROW($A$3)+1),ROWS(N$3:N3)))

Regards,
 
Last edited:
You must log in or register to reply here.
Back
Top