sort and filter

  1. G

    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...
  2. Z

    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...
  3. A

    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...
  4. S

    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...
  5. D

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

Watch MrExcel Video

This Week's Hot Topics

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