I work for a trucking company and I have a list that shows the amount of loads done by each driver. Each row represents a different load (From origin to destination).
I need to find out if a driver works more than one load on that day. I want the column to display the number load this driver is on for the day.
December Template Test 12-18.xlsx
The column i'm working on is "AB" entitled "Driver Loads".
I have found a simple countif statement that works to tell me which number loads in that day based on all of the drivers.
I need it to be driver specific as well.=COUNTIF(C$3:C4,C4)
Something like this
=COUNTIF(C$3:C4&M$3:M4,C4&M4)
any help is greatly appreciated
Bookmarks