Find Cusomer Name

[shaileshgavanang]

Hi,

I have my custmer names in one sheet which are repating.

I want list of customers in 2nd sheet but name should one time only not repeat.

is there any way.

at present what I am doing is i am copying the all names in 2nd sheet, arranging in alphabatical order & deleting the duplicate names.

please sugest any formula for this

thank you