sort filter excel

  1. S

    Excel Filters Greyed out after selecting a certain row/column?

    Hi there, I have come across a new problem which I've not had seen before in Excel 365 version. 1. After a certain ROW and COLUMN my filters are not working - I have cleared the filters, checked blanks, etc but when I select the entire data "Filter options" are greyed out as per image below...
  2. C

    Filter,Sort, or ????

    I've got a spreadsheet and I need to sort it so that I only see the entries that work in either NY or CA (which I've done with a filter) and have sales LESS THAN 4000 OR Assets GREATER THAN 10000 (which I can't figure out). Sales and Assets are two different columns and I can't find a way to...
  3. W

    How do I sort a table of data with more than 3 criteria's?

    Hi all I've got a spreadsheet that lists driver deliveries based on multiple drops within his route. The driver may have to come back to base and go out a 2nd time with another route (eg: trip 2, 3, 4 or 5). I want to sort the spreadsheet by Deport depart time (spread over 2 days which may...
  4. M

    Sort Limits?

    Are there limits on the number of rows Excel will filter? I have a spreadsheet with 10,000 rows of data. One of the columns is sorted and then captured onto another sheet in the same workbook to summarize the data associated with specific projects. Today I noticed that some of the data was...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top