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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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 =...
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...
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...
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'...
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...
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...
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...
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...
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)...
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 MrExcel.com.
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 "mrexcel.com".
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.