| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique Records in Column
Hi, In Sheet 2, Column A, all the values in the cells have been referenced from Column J in Sheet1! How do I now filter, Column A Sheet2, for Unique Records I attempted Advanced Filter - Copy to another Location - Unique Records Only, but this only returns Sheet1!L25 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unique Records in Column
You must first change the formulas on Sheet2 to values.
Gord On Sat, 17 Mar 2012 13:33:17 -0000, Yunus wrote: Hi, In Sheet 2, Column A, all the values in the cells have been referenced from Column J in Sheet1! How do I now filter, Column A Sheet2, for Unique Records I attempted Advanced Filter - Copy to another Location - Unique Records Only, but this only returns Sheet1!L25 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unique Records in Column
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unique Records in Column
Yes.
Or just copy and paste special values in the same column in Sheet2 but that may be inconvenient or undesirable. Gord On Sat, 17 Mar 2012 14:54:01 -0000, Yunus wrote: In article , says... You must first change the formulas on Sheet2 to values. Gord On Sat, 17 Mar 2012 13:33:17 -0000, Yunus wrote: Hi, In Sheet 2, Column A, all the values in the cells have been referenced from Column J in Sheet1! How do I now filter, Column A Sheet2, for Unique Records I attempted Advanced Filter - Copy to another Location - Unique Records Only, but this only returns Sheet1!L25 Thanks Gord, That's what I suspected, so it's Copy/Paste special/Values in another Column in Sheet 2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
| extract unique records from one column | Excel Worksheet Functions | |||
| Filtering for Unique Records with multiple-column criteria | Excel Discussion (Misc queries) | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
| In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) | |||
Linear Mode
