Print unique values
 

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


--
omnibrown
------------------------------------------------------------------------
omnibrown's Profile: http://www.excelforum.com/member.php...o&userid=30409
View this thread: http://www.excelforum.com/showthread...hreadid=500776

Print unique values
 

Hi omnibrown

Use Advanced filter
http://www.contextures.com/xladvfilter01.html#FilterUR


--
Regards Ron de Bruin
http://www.rondebruin.nl


"omnibrown" wrote in message
...

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


--
omnibrown
------------------------------------------------------------------------
omnibrown's Profile: http://www.excelforum.com/member.php...o&userid=30409
View this thread: http://www.excelforum.com/showthread...hreadid=500776

Print unique values
 

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

Select Sheet1 cell A1
EditCopy

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

Remaining on Sheet2.....
DataFilterAdvanced 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 [OK]

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=500776

Print unique values
 

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,

"omnibrown" wrote:


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


--
omnibrown
------------------------------------------------------------------------
omnibrown's Profile: http://www.excelforum.com/member.php...o&userid=30409
View this thread: http://www.excelforum.com/showthread...hreadid=500776