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