sort alphabetical

  1. V

    Custom sort

    Hi all, I want to sort a pivot based on the options Example: I have a data contains 3 columns, State_name, Lives (*integer), Coverage (*Percentage values) I have to create 3 options 1. Alphabetical 2. High to low - Lives 3. Low to High - Coverage If I choose any of the options my data...
  2. I

    How to repeating sort in excel

    Hi everyone, i'm struggling to sort in Excel. I have a labelled data from 1-5. What i want is the data sorted with repeated number. To help you visualize see the picture below. Is there any way to resolve this? Thank you
  3. D

    Alphabetically order a list with respect to column B

    Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David
  4. W

    VBA code to sort rows in alphabetical order

    Could someone please help me to create a small VBA script that is able to automatically sort the 10 rows contained within range A1:C10 in ascending alphabetical order, using the contents of cells A1:A10? Also, if I record a macro while manually performing the above sort just using the Sort...
  5. S

    Reverse sort within cell option for this VBA code

    Hello! I'm new to VBA and first would like to thank everyone posting codes that anyone can use!! I've found this very useful code to alphabetically sort words within cell separated by a comma. I'm wondering if i can tweak this to reverse sort? (Z-A instead of A-Z) Function StrSort(ByVal sInp...
  6. D

    Sorting Full Name Cells By Last Name

    Hi Team, I have a list of full names in a row that I need sorted by last name. I know I can separate the first and last names by using Text To Columns and the space as a separator, but I was wondering if there was a clever formula to spit only the last name out into a helper column...
  7. K

    Loop through Dir and open files alphabetically

    Hello, I have a macro which I have been using to loop through all files in the directory which contains my spreadsheet with the analysis macro. The macro works perfectly, except for the fact that I just discovered that using Dir does not return files in alphabetical or file system order, but in...

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