Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to copy UNIQUE data from a column in a SINGLE CELL
I would like to copy UNIQUE data from a column in a SINGLE CELL
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to copy UNIQUE data from a column in a SINGLE CELL
more info please
will there only be one unique item? is it text or numbers? What is definition of unique in this case? an example would be useful "Yogi" wrote: I would like to copy UNIQUE data from a column in a SINGLE CELL |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to copy UNIQUE data from a column in a SINGLE CELL
Hi,
What do you mean by unique, column and cell. Please elaborate ... However, you could follow the procedure mentioned below: Filter for unique records 1. Select the column or click a cell in the range or list you want to filter. 2. On the Data menu, point to Filter, and then click Advanced Filter. 3. Do one of the following. To filter the range or list in place, similar to using AutoFilter, click Filter the list, in-place. To copy the results of the filter to another location, click Copy to another location. Then, in the Copy To box, enter a cell reference. To select a cell, click Collapse Dialog to temporarily hide the dialog box. Select the cell on the worksheet, and then press Expand Dialog . 4. Select the Unique records only check box. Note: Once you filter for unique values, you can copy them to another worksheet and then archive or delete the original worksheet. Challa Prabhu "Yogi" wrote: I would like to copy UNIQUE data from a column in a SINGLE CELL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing data from one column within one single cell ? | Excel Discussion (Misc queries) | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
Copy column of cells to a single cell? | Excel Discussion (Misc queries) | |||
Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions |