Thanks for your reply, the "Count no of products column" is the expected results. I want to get this result based on Formula. The customer ID could be anywhere in the list, Since the criteria is Customer, Year, and Product sorting doesn't help. So I need a formula.Dhanraj27
eg Customer's 1 the 1st .. purchase(?) .. year (Booked Date?) is 2017
Customer .. buy (?).. two different products - TV & Mixer - both two (Count No of Products).
What would be Your expected results?