Re-using a saved filter

Good morning

I have a large spreadsheet, about 30MB and a bazillion cells.

Again and again I am applying the same filters.

Is there a way to save a filter so that I can just do a few clicks and can re-use the filter ?

Thanks

Duncan

Added some time later . . .

I am talking about these filters:
\1
\1
\1

Sorry, the images do not show up, you can click the image-links below if you want:
https://i.postimg.cc/sXHJK7yf/Screen...-27-140934.png
https://i.postimg.cc/s2TV6DLD/Screen...-27-141117.png
https://i.postimg.cc/2yP7NYVP/Untitled.png

I am only interested in the text filters.

If you can take a time & small worksheet attach with required output its easy to understanding.
Refer yellow banner on top of page. how to attach file.

Hi AVK

I am not sure what you are asking.

Will include some images in my first post. Perhaps that will explain it a bit better,

Save your small excel file.

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

@Duncan

While you have given us a file, you have not given us much to work on. What filters do you wish to save. Is the file you presented representative of your actual file. We need more information if you wish for help. We are experts people and not mind readers. Provide us with more detail on what you expect your results to look like. I don't know what you want. Help us to help you.

Hi Allen, thanks for the response.

Originally Posted by alansidman

What filters do you wish to save.

Any that I wish. Until now I am still in the dark if it is even possible to save a filter to be used later.

Is the file you presented representative of your actual file.

No, my actual file has millions of cells and is over 30MB

We need more information if you wish for help. We are experts people and not mind readers.

Just let me know what info you need.

Provide us with more detail on what you expect your results to look like.

I am hoping after setting any filter, using the standard excel tools, I can save this setting. So set another filter, and then if needed go back to the saved setting.

Of course I can save the spreadsheet under a different name, but that is not what I am after. My goal is to have a few dozen of preset filter that I can select when I need it.

I don't know what you want. Help us to help you.

I would like to re-use a saved filter. If that possible ?

Your responses don't help me to help you. I'll be travelling for the next two weeks with out internet. So I'm out. Good Luck and maybe someone else can sort out your needs.

If you go with search engine, lot of example available. I post one of link, hope this help you.

PHP Code: 

https://www.contextures.com/excelfilesfilters.html