sort

  1. B

    Excel - sort data (smallest to largest) with 2 or more criteria in formula?

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

    special sort on telephone numbers

    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 <colgroup><col style="mso-width-source:userset;mso-width-alt:3140;width:69pt"...
  3. K

    Bowler Chart for KPI using sorted merged cell

    Hi. 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...
  4. V

    Different sort criteria in single data set

    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"...
  5. R

    custom sort not applying

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

    Formula to Sort a Subset of Conesecutive Positioned Values of an Array with Constant Values?

    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? Moreover, an...
  7. M

    Specifying a Worksheet with VBA

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

    Can you save a sort in a Custom View?

    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?
  9. B

    VBA: Sort Range after New Data

    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 Unload...
  10. H

    Macro to print and sort range

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

    SKUs not sorting by numerical order

    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: 5-part 7-part 156-part 691-part When sorting, from smallest to largest, it...
  12. M

    Build a Sort Dynamically

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

    Custom Sorts in Pivot table

    Hi there 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...
  14. T

    VBA Code - Sort by Custom List Reference

    Hi there, 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...
  15. P

    Data sort by VBA

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

    Slicer Settings Do Not Show Custom Sort Option

    Hello 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
  17. S

    Sorting Code (alphabetize) stopped working

    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.... Range("B3:K102").Select...
  18. H

    Auto Sort from multiple list by Name

    hello All, 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...
  19. C

    Sort List in Ascending Order Using Only Excel Tokens [hard puzzle]

    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. https://www.homeworkhelponline.net/blog/programming/excel-puzzle
  20. G

    Automaticly sort rows by date

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

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top