Dear All,

I have a database in sheet A. the fields such as Sales Name, Product, Unit
Price, etc.
(E.g. the database contains 100Records, where Sales Name are repetitive
depends on the product sold). More spesific, there are 9 Sales Name in that
databse.

I would like to make the Sales based on Sales Name in Sheet B.

So i need list down those 9 Sales Name using FORMULA (i dont want to use
Pivot table). Please guide to to display those name in Sheet B, Cell A1:A9???

Thank you for your kind attention and help.

Respectfully,
andri