Is it possible to have a sort and filter button for specific rows then another sort and filter button x rows down in the same column and how?

PartsPig

New Member
Joined
Sep 13, 2024
Messages
9
Office Version
  1. 365
Platform
  1. Windows
MrExcel.PNG
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
If I understand your question correctly, select the first 9 items and the line Daily Procedures and then insert them as a table, with my table has headers checked and then repeat down the line for each section of your data, creating different filters for each specific data set.
Generation Names
X
Y
Z
Millenial
Alphas
Generation Numbers
1
2
3
4
5
 
Upvote 0
Solution
Ignore the fake data table I created. Does this make sense?
 
Upvote 0
If I understand your question correctly, select the first 9 items and the line Daily Procedures and then insert them as a table, with my table has headers checked and then repeat down the line for each section of your data, creating different filters for each specific data set.
Generation Names
X
Y
Z
Millenial
Alphas
Generation Numbers
1
2
3
4
5
That worked perfectly!!! Thanks for the guidance!
 
Upvote 0

Forum statistics

Threads
1,223,997
Messages
6,175,874
Members
452,679
Latest member
darryl47nopra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top