Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting unique records similar to the primary key in access
I want to get unique records in excel where only certain column values should
be different and others are same. Similar to what for we have primary key in access. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting unique records similar to the primary key in access
Highlight the column where you want unique values (works best with a
header row), then Data | Filter | Advanced Filter. Here you can choose unique values only, and elect to filter in place or to copy (extract) the values to another location (you specify where). Click OK and it's done. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import records from Access to Excel | Excel Discussion (Misc queries) | |||
Extract Unique Records from two lists | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
filtering for unique records | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) |