| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy unique cell - ajit
I have over 3000 values in column 1 which have duplicate values. I want to
copy only unique values in another column. How Can I do so? -- Knowldege is Power |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy unique cell - ajit
Hi,
Select you column of data then Data|Filter|Advanced filter Select 'Copy to another location' Type the address of the topmost cell in the destination box or navigate to it Leave criteria box empty check unique records only Click OK Mike "Ajit Munj" wrote: I have over 3000 values in column 1 which have duplicate values. I want to copy only unique values in another column. How Can I do so? -- Knowldege is Power |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy unique cell - ajit
Dear MIKE
Thanx. I did it. But for testing purpose, I fed 1,2,3,4,1,3 in another sheet and experimented. When I copied the same data with Advanced filter with unique records only box checked, value 1 got copied twice. How comes? -- Knowldege is Power "Mike H" wrote: Hi, Select you column of data then Data|Filter|Advanced filter Select 'Copy to another location' Type the address of the topmost cell in the destination box or navigate to it Leave criteria box empty check unique records only Click OK Mike "Ajit Munj" wrote: I have over 3000 values in column 1 which have duplicate values. I want to copy only unique values in another column. How Can I do so? -- Knowldege is Power |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy unique cell - ajit
Your data needs a dummy heading too. The first 1 was assumed to b heading.
-- Best Regards, FARAZ A. QURESHI "Ajit Munj" wrote: Dear MIKE Thanx. I did it. But for testing purpose, I fed 1,2,3,4,1,3 in another sheet and experimented. When I copied the same data with Advanced filter with unique records only box checked, value 1 got copied twice. How comes? -- Knowldege is Power "Mike H" wrote: Hi, Select you column of data then Data|Filter|Advanced filter Select 'Copy to another location' Type the address of the topmost cell in the destination box or navigate to it Leave criteria box empty check unique records only Click OK Mike "Ajit Munj" wrote: I have over 3000 values in column 1 which have duplicate values. I want to copy only unique values in another column. How Can I do so? -- Knowldege is Power |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data as is seen - ajit | Excel Discussion (Misc queries) | |||
| I would like to copy UNIQUE data from a column in a SINGLE CELL | Excel Discussion (Misc queries) | |||
| filtering unique records ajit | Excel Discussion (Misc queries) | |||
| copy conditional formatting with 'unique' cell references | Excel Discussion (Misc queries) | |||
| format cell for figures - Ajit | Excel Discussion (Misc queries) | |||
Linear Mode
