Hi All
I am after a formula (preferably subtotal), whereby I can sum only one instance of a duplicate. From the below data for eg, I want to return a sum value of 110 for R1087 and not 220.
Cheers
R1087 110
R1087 110
R1086 710
R1086 710
R1086 710
R1086 710
R1045 600
R1045 600
Bookmarks