sort values

  1. J

    Can't sort values in new categories!

    Hey! I'm working on a project in PowePivot were I have a database with different roads and there average length in km. The range in length goes from about 20 km to 230 km. What I want is to sort these lengths into 5 groups; 0-50 km , 50-100 km, 100-150 km, 150-200 km and 200-250 km. I've...
  2. F

    VBA: Sort values with IF condition

    Hi Guys, I have some Text ## values in a A1 and B1. And some text values in A2, A3, A4. Example: A 1. T ## 2. D 3. H 4. F What I need a script which sorts the text values in their alphabetical order variations according to conditions given below...
  3. O

    Identifying and Sorting Unique Entries

    :warning:PLEASE HELP ME WITH THIS!!!:warning: I am being very detailed in this, so I hope there's no confusion... I'm still a newbie, but I'm starting to get the hang of this though writing macros is still hard. I have a project which requires that I check over 50,000 rows of data to make sure...

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