Thank you, I have applied it to the sheet and have changed the cell it is working off however I do not think it is fully working please see attached.

There are cells returning a Zero instead of 1 or 2 etc

also as this formula essentially creates a new units column is it possible to have it return the sum as well as the individual numbers of the other cells or a zero if it has been summed? please see below.

Create an ODBC query with DISTINCT clause, which reads unique data from table with double rows and writes result to another sheet. You also can use SUM, AVEREGE, MIN, etc in query to get some aggregate values. Or you can use formulas like SUMIFS or COUNTIFS in adjacent columns to query table to calculate aggregate values from original data table.

I added edited RawData.xlsm file, where ODBC query is used to consolidate your data.

The format *.xlsm is used, as I added an Open event which corrects query parameters on open automatically, whenever the file name or location is changed. Without this this script allowed to run, you have to edit the query datasource manually every time you relocate or rename the file.

In your original table, I removed a couple of spaces from column names.

As source table for query I defined a non-dynamic named range nData. Currently it has 20000 rows - when your table has more rows, then edit nData.

Along with sum of Unit's I calculated also the number of deliveries and min of FromDate and max of ToDate.