Unique list

Hi,
Please help me on this.

I have Names in column "B" and their respective quantity in column "C".
I want to extract unique list of names basis on their quantity in column "E" (please ignore zero, blanks and total)?
Please refer the attached file.

Thanks for the assistance.
I have already mocked up my result in column "E".

Hi

Try using a simple pivot table.
See the file

Thanks for your assistance, but i want this to be dynamically unique list using formula.(no vba and pivot).

E3 array formula

HTML Code: 

Thank you so much for your help. It is working.

if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add reputation there

If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved

Thank you this solution works for me as well.