I have a list of customers over the past 4 years, they are differentiated by
customer numbers.

What I would like to do is in one cell per year give me a unique customer
count for that year.

Then in another set of cells per year I would like to get a unique sum of
all purchased parts.

Customer number is A1$1
End date is G1$1
Pricing is H1$1


Any suggestions


--
Neall