Thanks Naresh for your Support. Brilliant !!Hi,
Pls check attached file if it is ok for you..
I have added extra column "A" in your master sheet to convert your details in to a unique count and used "Vlookup formula" only
Also note that i have deleted most of of data from your master sheet as the file is too large and it is not allowed to upload
regards
Naresh
Thanks Rahul for your support. The good thing is many Experts came and give different ways of getting the output. Awesome !!hii @@fareedexcel ,
Pfa attached sheet With refresh Button
Regard
Rahul shewale
Dear Expert, I was thinking instead of selecting from Drop down is it possible to do with Slicer and you have made it. I'm feeling happy with your results and at the same time i want to learn VBA Macros. But i'm not even good with formulasSee attached (pivot table solution).