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...