driver

  1. A

    Index Match Countif Distinct unique values with two or more match columns with result in two different tables.

    Hello, I wonder if anybody can help me out. I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values. I was able to do this so far with Index, Match and Countif array formula but it only works for...
  2. N

    Email multiple reports to specific addresses

    Hello, I need to email out a list of individual reports to specific addresses. The reports are located in C:reports and all have the same naming convention. Below is an eg of the spreadsheet and the data. Paste starts from A1 <tbody> AssetName Driver email Manager email1 Manager email2...
  3. A

    Vehicle rotation count

    Hi, I want to know in a day & month a vehicle doing how many trips. Basically rotation of the vehicle. Abbreviation codes: Driver Code GU- Gurdeep G- Gafar G1- It will show the that driver done the multi delivery in this trip. For Example- On 2 June Gafar driver done four trips (G1 to G4)...
  4. S

    Ok in WinXP, but error in Win10 - Microsoft ODBC dBase Driver (*.DBF) Datasource name not found and no default driver specified

    Hi Guys I have maintenance old macro, this macro work in WinXP 32bit & Office 2010 but now user need to upgrade computer into Win10 x64 & Office 365 there are a problem when accessing this code data_path = Left(ThisWorkbook.Path, 31) cn_bank.Open "driver={Microsoft dBase Driver...
  5. S

    Pivot Chart Layout

    Hi everyone, I want to make a pivot chart to track performance of drivers in a race series. I can make it as a normal chart, but would like the have the filter options to remove certain drivers, or compare directly. I'm unsure on how to layout the data source, and seem to be having issues...
  6. N

    vba and MySql

    Hello, is it possible to query (select) a mySql database (WordPress) with VBA ? and if so, how ? do I need to install some driver or somthing else ? Thanks !
  7. B

    Spreadsheet idea containing formulas over my current skill level...

    Hello all, This is my first post here so hello everyone, pleased to meet you all :) I'm a self taught Excel user so my skills at this stage are unfortunately a bit limited and quite rough on the edges as well. I recently started working for a new company and I'm working on a spreadsheet...
  8. T

    PowerPivot Security/DSN issue?????

    Hello everyone, I have worked with PowerPivot for my own uses a fair ammount, but recently I was asked to create some reports for other users, and I am getting connection issues that I dont understand when they try to refresh the data source connection. I will put the error message bellow, but...
  9. P

    Drivers milage / time sheet

    Hi everyone. Need help please. We have a spread sheet for monitoring drivers mileage and work times as sample below. Date Driver Start Work Finish Work Start Milage Finish Milage Time Work Milage Total Time Total Milage 1/9 Ted 06:00 13:00 100 150...
  10. P

    Help with a drivers milage / time sheet

    Hi everyone. Need help please. We have a spread sheet for monitoring drivers mileage and work times as sample below. Date Driver Start Work Finish Work Start Milage Finish Milage Time Work Milage Total Time Total Milage 1/9 Ted 06:00 13:00 100 150...
  11. B

    Transpose column data to one row

    I am looking for a formula to do this if possible, but VBA will work if not available as a formula. So, in column A there are dates, column G has a driver name, column L has either LF or DT two show either landfill or downtime status. Over in column R I have weights of the landfill load, but...
  12. J

    Compare data from 2 columns pull unique rows

    I would like to compare 2 separate columns and list out unique rows in another sheet. Column 1 Column 2 Column 3 Column 4 Column 5 MOW204000235 1 No No Vehicle Maint. MOW204000235 1 Yes No Driver Fitness MOW204000235 1 No Yes...
  13. M

    Formula to Return 5 Highest/Lowest Scores from Pivot Table

    Hi All, I have a pivot table which contains a row of months with a column of employees. I have sorted the data with highest scores first, but don't know how to write a formula which returns with the top 5 highest/lowest employees per month. Also, as in the example below, there are blanks in...
  14. R

    Time format in text

    Hello, I have the below formula: ="The average driver worked an average of "&ROUND(AVERAGE(F48:G48,H48,F49,G49,H49,F50,G50,H50,F53,G53,H53,F56,G56,H56,F57,G57,H57),0)&" hours per week" The above gives an answer of "The average driver worked an average of 2 hours per week"... I need an answer...
  15. D

    Auto sum numbers based on previous number and a given number

    Hi, I have a delivery company and want to create an incentive tracking sheet. My drivers will start accumulating fixed commissions after a certain number of deliveries (below chart); <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody>...
  16. H

    MSQuery on a MAC

    Good morning All, I am trying to open a spreadsheet which is on a shared driver (workbook was setup using a windows machine). The workbook has a macro to refresh itself every time on opening. However when I try opening the workbook using a Mac (my boss's machine), it comes up with the following...
  17. M

    Rota/Schedule that self populates

    Afternoon all, I need some help. I would like to create a 6 week rota that show 15-20 drivers shift pattern. Now this is where it gets complicated. I need to it be easy for me to print and hand to a switch board operator and understand. So the rules are: Driver 1 will work 4 x 12 hours days on...
  18. M

    SharePoint & file with code/userforms

    I am developing a file that will need to be used by only 2 people at the same time but the file contains code and userforms. The file will consist of the following sheets Drivers Master List Driver List Availability Master List Availability List The initial data will be added via a userform...
  19. P

    Vlookup?

    Hi, Not sure what / how to do this. I need to lookup vehicle registration number + data as per below (below is what I have in one excel tab. Date Van Reg Driver Name 23/10/2017 ABC 123 ? The other tab contains...
  20. A

    Multi rows into Single row using power query

    Hello All, how can I convert multi rows data into single row using power query.. My above column must look like the below comlumn.. Thanks.. <tbody> Driver Name Driver ID Bus Number School ID School Name Timing David 1005 F5002 A123 Helen Model School 7:15 David 1005 F5002 A300 Stuart High...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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 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.
Go back
Top