1. M

    Function Not Working - Sort & Remove Duplicates by Creating New Array

    I am not well versed in VBA and have no idea where to start finding the issue here. I need to write a function that will take a 1 dimensional array as an input and spit out a new array with all the values sorted alphabetically and duplicates removed. This input "SourceList" column has text...
  2. M

    sort/match columns on same value and skip missing

    Hello, Im new here and i've got a question. I'm making a yearbook for students and i want to check if everyone has filled in the forms enquete. I download a forms sheet with the input from the students and now i want sort the data with my other excel (The excel with al the names) How can i...
  3. B

    VBA code to align data monthwise/Horizantally

    Hi All, Can someone help me with below requirement. I have data sheet1 where there is "Month" header is column "I" and "COUNT" header in column "M". Sample data looks like below. Number Name MONTH COUNT 121 Ram February 40 132 Carey February 32 125 Salim February 40 127 Kumar...
  4. M

    Sort list by date, expanded selection?

  5. L

    Help figuring out how to do this.

    Alright, so a company that I work with makes racks for a large company to use. They are new and I go in every day and watch the racks when they get placed and make note of the rack number, time in and out, any issues that come from the robot etc. So we are trying to figure out now, an easy-clean...
  6. E

    How to distinguish duplicates using a SORT function

    I am sorting data from a large table (called Games) for the top ten fastest running times, I will be continually adding new data to the table and the top ten times may change moving forward. I have attached a picture to be used as a visual, which also includes the function I am using. The...
  7. W

    Auto Sorting an F1 league table

    Hi all, Looking for some help with an esports F1 league table so it will sort automatically when I input the positions based on the total points column. Currently when I enter the positions, the total points column uses a sumproduct from another table on the page to carry across the...
  8. S

    Sort data by route and stop order

    I have a worksheet with 10 columns of data but I want to sort the data by route and then by stop order: AB1RouteStop21131241351462172382292410311133123213341443154216411751185219522052 This is just the first 2 columns but it is possible to apply a sort in excel to give me my results by route...
  9. D

    How to Distribute data from a master tab to team tabs?

    Hello, I'm looking to figure out how I can distribute from a Master tab to a multiple of other tabs within the same workbook. I'm fairly new to Excel, self learning, but for some reason I cannot wrap my head around how to create this. I appreciate any help I can get. Thank you in advance.
  10. M

    how do I sort column by date while ignoring year?

    Hi, I have an excel file with domain names, and one of the columns displays their expiry dates in this format: MMM-DD Now, I want to be able to sort this list by month and day (in THIS order) - so, completely ignoring the year - so I can easily see which domains are approaching renewal date so...
  11. P

    Dynamic cell and sorting

    So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By dynamic I mean that no matter the order of the Excel table, cell E4 should always report the correct tag associated to the description. How can I achieve...
  12. T

    Auto Sort Birthdates

    Hello I am hoping someone may be able to help me. I have a list of birthdates and in my job, I have to purchase gifts for everyone's birthday. Ideally, I like to do this 3 weeks before the birthday comes up to give me time to buy the gift and get it sent to them in good time. It would help me...
  13. I

    Can you sort sort specific data in one column based on values from another column using VBA?

    Hello. So I have this one workbook. It has arrival times in column A. Route codes in column B. And staging areas in column D. So a route code arrives at the time in column A and staged in the area in column D. I have many vba codes for this unique workbook. All route codes in column B start with...
  14. 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...
  15. 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...
  16. 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 =...
  17. 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...
  18. 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...
  19. 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'...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back