Forum Discussion
Excel filter
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.
* Knowing the Excel version and operating system would also be an advantage.
Finally, please consider why does one of the helpers still have to prepare the file with your request?
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE
Hi! Well said, I should have done it.
For example, I want to filter out all the row containing d
I can go to custom filter to select contains d
However, it is a one-time off filter
Is it possible for me to fix the list of filters, such that under (Select All) it only has contains "a", contains "b", contains "c", contains "d", contains "e". instead of abe, ac, bcd, cd, all these options
Hope these photos better substantiate my problem at hand.
Thank you so much!
- Sorry, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.
With the pictures you have inserted, you cannot see which additional settings may be present in your sheet, or which formulas are in the respective cells. At the same time, I don't know which Excel version is involved and which operating system you are using (not always necessary, but sometimes yes).
That's why I can't help you here.
Why does the helper create a sample file in order to guess what the helper needs in the best case?
I wish you have a nice day
Nikolino
I know I don't know anything (Socrates)