Hi all.
Could anyone please help with a division query.
The Lots have been split into separate lines from the codes in Column C.
The total cost of the Lots combined are in Column E
Is there a way to divide the total cost by the number of items in the Lot
As there are 7 items within Lot 668...