Forum Discussion
copy cell
The new FILTER function should work, if I understand what you're asking. That is available in the newest versions of Excel. Here's a reference site that can help you with the syntax for your own situation. If you need further help, please attach a copy of your actual spreadsheet rather than just an image.
https://exceljet.net/excel-functions/excel-filter-function
Hi
Just quick question in example its just red and blue
What if i have more criteria then 2 lets just say I have red , blue , black and white
how would i get to show all black and white
hope you understood the question
Just quick question in example its just red and blue
What example are you referring to? The one that started this chain? Or a purely hypothetical/imaginary one?
What if i have more criteria then 2 lets just say I have red , blue , black and white
how would i get to show all black and white
I presume you mean only black and white; stated another way, what you mean is "I have four conditions, red, blue, black and white" and you want to select rows meeting two criteria, satisfying either or two conditions. You do that, using filter, by using something like the following for the criteria section within the FILTER function. (CellRange="black")*(CellRange="white)
hope you understood the question
I hope so too. If not, please come back and clarify. Even better, attach a working sample spreadsheet. It's always easier to work with something closely resembling what one is asking about.