sort

I've got a macro below, row 2 is the heading (in a table), and I'd like to (in priority) filter I2: select the criteria UP, DOWN, LEFT, RIGHT, sort Z-A (descending). Then filter J2: sort Largest to smallest The macro is able to filter UP, DOWN, LEFT, RIGHT, but doesn't seem to sort from Z-A...

Is there a way to automate the sorting of a row a-z ascending but across not down. I add a new column in once a week and use a script to make it quicker however i was hoping i could always ensure the row is organised ascendingly without having to do anything? For example Row 1 Week1 Week2...

MSORT is a powerful and versatile array sorting solution that allows for sorting all or a subset of the columns (or rows) together or independently as well as having various options for dealing with the unsortables (blanks, logicals, and errors) MSORT takes five parameters, one required and...

It's 2024. Excel is 40 years old. Microsoft has known about the problem for at least a decade. Why can't they make a sort to sort a numeric column properly?? 1 is smaller than 10 or 11, and 10 or 11 are smaller than 110 and 111. It's not hard unless you tediously go through and add leading...

SEQUENCES is a powerful and versatile multi-SEQUENCE solution providing full control over "start" of each sequence as well as each of the "counts" and "steps" and having other useful features such as stacking and sorting The overall function parameters are similar to the native SEQUENCE...

Hi everybody I'm trying to write a macro to enable colleagues to sort a table on a protected worksheet. This table and worksheet are protected in regards to formatting to prevent unwanted changes to the tabel by colleagues who aren't very excel-savvy. Unfortunately, because of the locked...

Hi! I have a huge list (60,000) of contact data including information I want and a lot I don’t need. It is unevenly spread across cells in a way that isn’t patterned throughout (like some of the data is in correct columns but some is not). I basically want to delete the excess data and sort the...

Hello:), I need help rewriting my formula, I already succeeded in making it do what I wanted it to do. Now the problem is when I want to delete specific data from the new table it just sorted I can't modify it. Can anyone help me resolve this issue? Thanks...

not sure if this has been asked before but running into a slight issue- I have a data set this data set does connect to a live report. i need to be able to sort on different things such as date of inquirty or ttracking number or date sent or other things- when i sort by tracking number or...

I have a table (tbl) with columns of Site and Sale I want to Rank the Sales where Site is not blank. On Column C (Rank) I using =RANK.EQ([@Sale], [Sale], 1) but not sure how to exclude the Site where it is blank so that the resultset would be like Column D (Expected) Site Sale Rank Expected...

Hey all, After looking up guides, I tried to incorporate a line of code to mimic custom sort for my end product of this macro. Basically this macro takes existing tabs of active worksheet, copies them then perform some operations on them within the new worksheet. For some reason my sorting code...

Hello everyone, I have a lit of parts with part numbers in row b. Some numbers are only numeric and some part numbers start with "a-" (ex. 23443555, 3465787 ,A-10123 ,A-202454, etc.). I need to sort them by ascending order but have the parts starting with "a" on the top of the list. I can get...

So while I know, ultimately, that I can do what I'm about to ask with a custom sort, I have a shared spreadsheet that is constantly having rows added, and deleted (I.E. they add to the bottom, but might just delete row 5), which means that I would have to redo the custom sort EVERY TIME I HAVE...

I want to get a summary of the unique value under a condition. Like in the below table- 1. For article BD-01, the Sorted (A-Z) unique area code is 11, 12, 15. 2. Then for these Unique codes, there are some product codes. 3. Now I want to Join all Area code and their Product codes with separator...

Hello everybody, New to VBA coding. I have a dynamic table that is created from a macro based on another worksheet, a query, and equations. I then have a different module with the following: Sub SortTable(ws As Worksheet, tableName As String) Dim tbl As ListObject Set tbl =...

i have a table of 6 column first 3 tables already have data in it in a certain sort i would like to keep second 3 table which i will put data in i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1 let...

Good morning, I've searched everywhere, watched Youtube videos, and haven't had any luck finding what I need so I figured I would go to the experts of Mr. Excel to help me out! I have a pivot table in tabular format with all item labels repeating. I have 2 different rows and am trying to sort...

I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high) If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column If I choose High to low my pivot should get sorted in...

Hi I can't XL2BB as my work won't allow it: I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...

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