This is something I am struggling with. I have a large number of sheets in an excel spreadsheet that aren’t in date order. They are titled with batch numbers I.e “AB 100921A” or “AB 010616A” etc.
Is there a way to automatically put the sheets in order by the date within the batch...
Hello...I am a schoolteacher who wants to provide students with a chance to retake failed tests, and I want the data organized by class periods.
I am requesting a macro to perform the following sort functions:
Sort 1 is ascending from A2 to AT205 sorting by Column AT(Test Score)
Sort 2 is...
hi, I would like to discuss on how to get sorting ascending formula from this case. Expected result is as shown in the picture in blue column. The only reference that can be used is Rank column (Yellow) and Group column (white).
Any idea how to get the rank unique expected column (blue)? do you...
I’ve got a column of numbers starting in N4 for example
In the next column starting in O4, i’d like to place them in ascending order
I can’t work out how to do this.
Any help is very much appreciated.
I have data in a array variable with 8 columns, and I want to sort the array with condition, like
there is one of two columns in the array one is TA_Name and second is Trans_Date and want to sort the data as Ascending order (TA_Name) and Descending order (Trans_Date) or Ascending order...
I have a report based on a Query and I'd like a button on the report to switch between the Sorts below:
1. Sort by [Name] A-Z THEN [Date] Oldest to Newest
2. Sort by [Date] Oldest to Newest THEN [Name] A-Z
I'm guessing code is the easiest way but I'm unsure how to do this one.
In column A I have ranked people from 1 (best) down to 100 (worst) but they appear randomly.
In column B I have names of the people.
I need a formula that I can copy down for column C (which re-orders the rank numbers in column A) and column D (that reorders the names accordingly) that puts...
I'm still new to this but can someone help me how to set goal seek "set cell" must be in ascending
For example cell B83 "set cell" is the sum of B71:B82 (must be ascending)
and cell B85 is the "to value"
and cell b70 is "by changing cell"
also, cell b71 is a hard code cell
I have a user form set up to add a new part # to the worksheet, gather some data then create a new row adding that data once you click 'save' and that works fine but once the new row is added I want the sheet to automatically sort Ascending on column C...I've tried many different things and...
I have 1 column with names, each name repeated 20-50 times. Every row has assigned number ascending randomly 1-99. Must assign in filtered list (eg. 6000/30000 rows) counting numbers from lowest assigned to highest and start counting from scratch when reaches next alphabetical different name...
I would like to sort the column F in ascending with row one as header. The spreadsheet have 13 columns up to column M, I have done the code below but it needs debug:
Range("A2:M", Range("F" & Rows.Count).End(xlUp)).Sort _
I have another question please
This code complete a sort on column "B" starting with row 13 into Ascending order
What I would like is to sort two columns in ascending order at the same time
Column "B" first, then followed by Column "A"
[Set oneRange = Range("A13:K110")
Need help with some VB code please. I would like to sort data in ascending order based on column headers, the number of columns and rows may differ. So, sort ascending based on column header "Date".
Thanks in advance!
I like to solve my excel problems on my own, but sometime I stuck into a problem which I cannot solve.
I have a big database and I would like to sort prices in ascending order. But only inside for every four, five or six (or basically, any) rows. As I show it in the printscreen – and...
Greetings, thank you for clicking on my thread! I am in need of your help.
I am working on sorting a spreadsheet based on criteria in column C. Column C has a list of numbers, all of which are preceded by the letter A or B.
I want to write some...
My requirement is to renumber the values in a cell range.
If column e has 4 values of different numbers..
i want them to be renumber by ascending order.
like below output is
Could you please help out ...
I have a random list of numbers in column A (but not every cell has a number), and a name of color in B. I want to list all the numbers in Column A in ascending order in Column D and the corresponding color in Column E. Some of the number repeat, but the colors never do. This has to be...