'Sheet B'!A2: ='Sheet A'!A2
'Sheet B'!A3: =IF(ISERROR(MATCH(0,COUNTIF(A$2:A2,'Sheet
A'!$A$2:$A$20&""),0)),"",
INDEX(IF(ISBLANK('Sheet A'!$A$2:$A$20),"",'Sheet
A'!$A$2:$A$20),MATCH(0,COUNTIF(A$2:A2,'Sheet A'!$A$2:$A$20&""),0)))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter,
and copy down
--
__________________________________
HTH

Bob

"Andri" wrote in message
...
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