| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
| Populate combo box with unique values only | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Hybrid Mode
