sort

  1. E

    Sort from Z-A with condition

    Hi, I would like to sort the "Location" from Z-A for each order . The label "item" goes with the Location, they are pairs. Here is an example of what I want to do: ABCDEFG1OrdersitemLocationOrdersitemLocation21367-66-400112761367-66-4001127831311-12-141111191367-66-4001127641311-12-14111033...
  2. T

    Need VBA to find terms in column A and move the data in the cell to another column

    Hi all, I'm trying to self teach myself how to do this, and I cannot figure this out. Attached is an example of what I want to learn. If I have column A as my raw data, I want to have a macro that will search, for example, "apple" and move the data in the cell over to column B, search A for...
  3. M

    How to collate data in a single spreadsheet based on 4 criterias

    Hi all, New member here. I have a spreadsheet with the below format. So a single workbook would have 90-100 sheets with that same format. What I want to do is to collate all the data that match 4 criterias in a single workbook: Date, Oversees Manager, Overall Status, Assigned Contractor. For...
  4. S

    custom sort button vba

    i need two buttons to sort my data because some days i need my data sorted in way 1 and sometimes in way 2 so i need 2 different buttons for it way 1: its a custom sort on column M and the custom list is ( 24 H, 48 H, 3 days, 4 days, 5 days, 1 week, 2 weeks, 1 Month, 2 Months, Monthly, Yearly)...
  5. S

    How to create wildcard custom list on custom sort (custom sort contains sizes. s, m, l, xl)

    I would like to sort by first style and size. Since we have any styles with all size option. What would be best option. Tried with custom list with (s, m, l, xl) (*s, *m, *l, *xl) and did not work. Current sort style-lu-gd105-12pk-l style-lu-gd105-12pk-m style-lu-gd105-12pk-s...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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"...
  16. 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...
  17. 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"...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top