formula for removing duplicates.

[Kang]

how can I retrieve distinct rows? I need formula not through
menu("remove duplicates").

 

[Gary''s Student]

see:

http://www.cpearson.com/excel/Duplicates.aspx