Hi, I need help with Google Sheets please.
I'm trying to use filter with multiple condition & in each condition match with multiple value(list - this list is dynamic) & return multiple answers.
So far I can do filter with multiple conditions but only 1 value to match in each condition.
Or multiple value(list) match but for only 1 condition. I can't combine them together.
Please see the screen, any suggestion will be much appreciated.
Thank you in advance for your help!
Attachment 837962
It would be a lot easier for us to help you if you can share the link to a sample Google Sheets file.
You can go to this link, and submit the form to create a Sheets file for anonymous sharing:
https://docs.google.com/forms/d/e/1F...VbWiA/viewform
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Hi, thank you. I hope I did it right. Here is the sample URL
https://docs.google.com/spreadsheets...GwWsYxsNU/edit
I think the best approach would be to use QUERY, here is solution given in the sample file cell E20:
Please Login or Register to view this content.
Thank you this is very new to me and very helpful. However, if my data in date column formatted as Date then it turn #N/A, can the formula adjust to accommodate date format?
Thank you!
Last edited by mu6865; 07-28-2023 at 01:13 PM.
You will need to use ARRAYFORMULA, like this:
Please Login or Register to view this content.
thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks