sort

  1. S

    Rank players by different criteria

    Hi all, I am trying to create an excel data table that ranks players for each criteria on its own (points, rebounds, steals, assists, and so forth). Sample data for simplicity sake. table 1: players points rebounds steals assists playera 15 3 2 1 playerb 12 5 5 3 playerc 7 10 5 1 desired...
  2. L

    Sorting with merged cells

    Hi, I'm trying to sort the below table on the 'OVERALL' values, the issue I'm having is that as 'OVERALL', 'M/F' ... etc are all merged. When the sort is run essentially candidate 1 with all their data is sorted against all other candidates with all their data. Maybe some way of grouping or...
  3. L

    VBA error 1004

    I'm having a 1004 runtime error which I have been trying to workout for the past hour. Does anyone have any ideas? It shows the error on the ".Apply" line. Workbooks.Open (FileName) Set aWB = ActiveWorkbook aWB.Worksheets(1).Activate erow =...
  4. T

    Custom Sorting

    Hi, I'm looking to sort columns in a specific way in the attached image. Columns A & B - original data. Columns D & E - sorted data. Primary sort should be column B (Total), but duplicate fruit names should be clubbed together, regardless of the value of the duplicate fruit name. Can this be...
  5. B

    Dynamic Table Auto-Sort Using VB

    Hi all, I am trying to perform an auto-sort of a table using VB, where the table is dynamic using formulae rather than hard-coded data that is static. The table range is J3:R7 with row 3 being the table headers. When data is input, I need the table to update and sort based on the the updated...
  6. L

    Countif for more than one criteria

    Good evening everyone, I would like some help with a formula if anyone could assist. I have searched a number of forums and not had any luck! I have created a staffing list with various columns of information. On a separate tab, I would like to count how many times a name appears in column 'E'...
  7. D

    Automatically Sort Tables with Headers (VBA)

    Hi I'm trying to automatically sort the 2 tables on a spreadsheet using the macro below, however when the macro runs, it sorts the headers to the bottom even though I wrote xlYes for header. I think this may have something to do with the fact that there is data above the headers because it...
  8. 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...
  9. 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...
  10. 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...
  11. 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)...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top