Urgent

K

kiran

Hi All,
I have the follwoing data as shown below -
A
1 BRACES
2 BRACES
3 Primary
4 Primary
5 Oracle
6 Oracle

my question is I want to pinck the distinct names from column A and to print
in diffrent sheet.

TIA
 
F

FARAZ QURESHI

Insert a heading in the first row by inserting a row;
Select your Data, including the heading;
Open the DATA menu & select Filter;
Select Advanced Filter;
In the List Range insert the address of your data A1:A6;
Check the box "Unique Records Only";
Select the filtered list of unique records;
Press ( Alt + ; ) to select the visible cells only;
Go to other sheet and press ( Ctrl + V );

Best o luck
 
Top