# sort and filter

1. ### How to filter and sort according to a preset order in Google Sheets

I'm wondering how to use the sort and filter function in Google sheets to sort in ascending order the following: 1-2 months 2-3 months 3-4 months ...up to 11-12 months Right now when I sort 1-2months comes first, followed by 11-12 months. Is there a simple way to sort these fields according...
2. ### VBA To Sort Rows With Multiple Columns In A Range On Cell Click Or Double Click

I am using MS Windows Desktop and Excel 2019. After my epic fail with trying the Data Filter/Allow Edit Ranges method for sorting a locked worksheet, I need a VBA code for sorting to copy into 40 like-formatted worksheets within the same workbook. On each worksheet, I would like to sort the...
3. ### Top 25 Companies

Hi, I have a monthly/quarterly report that shows top 25 companies that we gained employees from. What I need to build a dynamic list that can be refreshed whenever I dump the updated data file and formula can be refreshed to update my list. I know using some formulas like rank, filter and other...
4. ### Counting text data until change in state

Trying to count the number of BOBs or WOWs in the BOB\WOW column before there is a switch from one to the other. It doesn't matter if the first cell is a BOB or a WOW I just need a numerical count on how many there are in a row before there is a switch. In each of the BOB\WOW columns I will do...
5. ### Sorting a rank automatically to another column

Building an Excel document for a competition. I have 3 worksheets. Sheet 1 - individual scores in each team with an overall team score. Sheet 2 - Team Score League Table Sheet 3 - Individual Score League Table In Sheet 2 I have ranked teams score (team order - they are numbered 1 - 20) and...
6. ### Rows below Sort & Filter range not showing after filter selections

I have sort and filter applied to range A1:Z100. the SUM formula applied within the sort and filter data area is outside the sort and filter range in ROW 101. When i apply a filter selection criteria, row 101 is hidden. data much further below the the filter range does show. It's like my row...

### 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.

### Which adblocker are you using?

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

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