I am trying to find result of sort data in table with specific criteria
for example :
The picture of excel-table that i trying to figure it out
yellow is ALL-JOB fill by user
RED is Unfinish JOB sort by "START DATE"
Green is Completed JOB sort by "END DATE" and "JOB ID"
i need to sorting data...
hi guys i have a table below.
In example a if i do the simple sort function i get result A, But i need to get to result B can anyone help me with this ?
Result A Result B
I know this is possible bc my intern was able to do it but now that I'm trying to replicate it....I can't seem to figure out how he did it.
Before everyone asks about changing the format, etc. it is not an option. We use a "bowler" chart which tracks the plan vs actual for key metrics...
This is one for a hobby. I have a card collecting spreadsheet that lists all available cards with columns for various stats like name, weapon, class, etc. Final column is either owned, wanted, or just blank. I set up a quicky VBA macro to sort everything by my desired "order of columns"...
I've recorded a custom sort.
The sort works exactly how I want, when manually applied (during record process), but fails to apply when applied by executing recorded vba code; by fail, I mean not applying sort and no error messages displayed.
After the code has completed, I can visit the "Custom...
I am looking to figure out in Excel 2016 how to write a formula that will sort a subset of values in consecutive position within a larger array with constant values (zeros), but keep those zeros in their same positions thus keeping the number of values in the array the same?
Hi Excel Experts,
I am struggling with how to reference a Worksheet in VBA and hope someone can help me.
I have a macro enable book where the code opens a different Workbook and copies the first worksheet to the macro book.
Once the code has done its thing I need to sort the results. I had...
Okay, I've sorted my sheet the want want to view something, and have saved it as a Custom View. When I remove all of the filters, and test the view by selecting it, everything works except for the sort. I'd like for it to sort from smallest (number) to biggest.
Is this possible?
Is it possible to sort the range a to z after the code below.
Private Sub CommandButton1_Click()
Dim newEntry As Variant, rws As Long, adr As String
newEntry = UserForm4.TextBox1.Value
rws = Range("Grades").Rows.Count
Range("Grades").Cells(1, 1).Offset(rws, _
0).Value = newEntry
Hello all not sure if what im needing is quite possible.
Im needing a Macro to Sort a range and Print it without haveing to Sort the actual excel. Just need the Sorting to occur for print purposes not to effect the actual excel.
I've seen this asked many times on the internet but I can't seem to find someone asking how to sort part numbers that also contain text. For example, I have the following part numbers and want them sorted in this way:
When sorting, from smallest to largest, it...
I am trying to work out how to build a sort when I do not know at the outset how many columns I need to sort on.
The first object was to see if I could pass the range and sort key dynamically. The following Macro does that getting range and column to sort by. When I try and build the entire...
I wounder if someone can point me in the direction as I have a brain freeze.
I have a large dataset of around 12000 records with around 16 columns . I have a start date and end date in 2 columns and I convert that into another column with the month as text from the From to cell date so...
I am trying to sort my data which is located under headings A52:K52 by the account number order, as stipulated in cells K21:K35.
This is my attempt but it is possible I'm way off the mark. Can anyone see how I can get this working please?
I don't want to refer to a particular sheet...
Hi to all of you, kindly require to provide me support so that a VBA code, should sort in an "ActiveSheet" its data used, which start from "A12" till column "K" and "rows down". Therefore that the rows arises to 800000+ and should be sort by col. "F". Thank you all in advance
I made a pivot table add to the data model of the query Connection.
There is no use custom list when sort in my slicer setting and I have encountered sorting problems.
thank you for any help you might provide
This line of code used to work. Now this, among a few others, doesn't seem to work. It kicks up a 438 "Object doesn't support this property or method" code and highlights the top line.... ideas? I can sort if I manually highlight and click sort....
I have a list column A is First Name Column B is Last name column C I have
C2= CONCATENATE(B2,","," ",A2)
Puts it in "Last name, First Name"
What im needing done on another sheet is to automatically sort when a name is added/deleted from the list in Alphabetical order based on...
Somebody might be interested, this is not an easy task. It asks to sort a list using only excel formulas, but not a sort. So you have to use array calculation knowledge and so on.
I cant figure out a code, to make the rows sort based on the date, given in column B (From B5). Our Company cannot use Automatic macros (Do to Citrix), so would prefer a module that I can connect to an icon or a button click.
The colums from A to V are in use, so the entire row needs to be...