sort blocks of rows

  1. J

    Sort based on column values then repeat

    Hi all, I have a worksheet that looks something like this: <tbody> Person# Stuff # Data Person1 1 Person1 stuff 1 Person1 2 Person1 stuff 2 Person2 2 Person2 stuff 2 Person2 4 Person2 stuff 4 Person2 3 Person2 stuff 3 Person2 1 Person2 stuff 1 Person3 2 Person3 stuff 2...
  2. I

    Sorting Help

    Hi all, I have a little problem sorting two columns in excel; my challenge is to sort from two column just the values that don't have any match. So here is a little exemple: <tbody> A B C Value 1 value 2 Value 1 Value 3 Value 1 Value 2 Value 5 Value 4 Value 4* i wanna higlight the...
  3. M

    Sorting data takes a long time for large amount of data. any shortcuts

    Dear Friends, Please find the code for sorting data: Sub SortData() Dim nLastRow, Rownum As Integer nLastRow = 0 Rownum = 0 Worksheets("Sheet2").Activate Sheets("Sheet2").Select nLastRow = Range("A" & Rows.Count).End(xlUp).Row ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.clear...
  4. M

    Sorting where Rows have merged cells

    I have a sheet which has data in repeating blocks of 5 rows identically formatted. The first column is a merged cell cells A1:A5, and then below that is a merged cell of A6:A10 etc down the page. i woould like to sort on that first column with the merged cells and have it drag along whole...

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