sort

  1. N

    Combining multiple rows into single row

    I hope someone can help. I have the following table in excel: 1 ID CREATED DATE FIELD NEW VALUE OLD VALUE 2 001 2020/01/15 Language German French 3 001 2020/01/15 Latest Outlet a001 a002 4 001 2020/01/15 Latest Outlet Parndorf Provence 5 002 2020/01/16 Language French English 6...
  2. F

    Sorting data in rows by number order

    I currently have a list of soft skills in cells P2, P3,P4 down to P14 and next to these in cells Q2, Q3, Q4 etc are rankings out of 10. e.g. cell P2 contains the text "highly motivated" and Q2 contains the number 8 (for 8 out of 10) I have just manged to sort the numbers in column Q into...
  3. S

    Sort Blank cells to bottom in a descending sort in VBA

    I am sorting the following columns independently and in descending order, i.e. the largest value in each column will always be in the top row. However, I have several blank cells in the table. These are not actually blank, but rather the formula e.g. IFERROR(H2/I2,"") gives a blank answer. I...
  4. D

    Condensing Column A to Remove Redundancies (Remove Duplicates and Consolidate doesn't do it)

    Hi! Thank you for reading this one. For an example of what I am trying to do, lets say I have a sheet that is about 200 rows long by 15 columns wide. It is one sheet with multiple bills-of-materials stacked one on top of the other. Column A has the master/parent numbers and Column B has all of...
  5. B

    How to sort 540 excel files based on H column by a VBA code?

    Hello all I have 540 excel files (different in file names) in D:\Mrexcel\Fluff. The inside arrangement of them all is similar. The only difference is in the position of the last cells. Some have 6 rows in total, and some have the last row in 700. I want to have a code to sort all the files by...
  6. F

    Issue with Filtering

    Hello forum, Basically I have a questionnaire (Button) that allows me to filter the room and it shows everyone in the room. Is there a way that once I filter the room and then filter the people in the room without loosing the room filter. Example: If I filter by Room 2, I will see Designer...
  7. E

    Return unique values based on multiple conditions and sorted by date

    Hello, I have data similar to whats shown in the "Orig Data' table. I would like to pull unique Names only, based on two criteria (Start Date <= today AND End Date >= today. I would also like the data sorted (oldest to newest) based on the Name's corresponding End Date . My goal is to have a...
  8. A

    Dates show DMY in cell, but MDY in formula bar - won't sort or convert

    Hello - I'm using O365 in the US but have system time on my PC set for Australia (in case this matters…) WorkSheet #1 I have received two excel worksheets, one has dates formatted in DMY, and if I switch the formatting of any of those cells to General, I see that the resulting number (in...
  9. 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...
  10. 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"...
  11. 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...
  12. 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"...
  13. 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...
  14. 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...
  15. 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...
  16. 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?
  17. 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...
  18. 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.
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top