Print unique values

O

omnibrown

Sheet 1 Col A has a list of text values, the list has cells with th
same value repeated. On sheet 2 col A I want the list of unique value
from sheet 1 col A. Easy
 
R

Ron Coderre

Assumptions:
Sheet1 has the original list
Cell A1 on Sheet1 is the column heading for the list

Select Sheet1 cell A1
Edit>Copy

Select Sheet2 cell A1
Press [Enter] (to paste the column heading)

Remaining on Sheet2.....
Data>Filter>Advanced Filter
Check: Copy to another location
List range: (Switch to Sheet1 and select the list, including the heading)
Copy to: (Switch to Sheet2 and select cell A1)
Check: Unique Values
Click to expand...
Click [OK]

Does that help?

Regards,
Ron
 
A

Ashish Mathur

Hi,

Assuming you have yout list in range A11:A14 of sheet 1, enter the following
formula (Ctrl+Shift+Enter) in cell B11 of the same sheet

=IF(OR(EXACT(A11,A12:A14)),A11,"")

Regards,
 
Top