Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which record is deleted when I use the "remove duplicates" functi.
I want the oldest record to be deleted, not the newest when I find the same
customer - how can I ensure this happens? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which record is deleted when I use the "remove duplicates" functi.
Hi,
what does your data look like? How do you know which record is the oldest? What if there are more than two records? Could you should us a sample data layout? -- Thanks, Shane Devenshire "amcellhinney" wrote: I want the oldest record to be deleted, not the newest when I find the same customer - how can I ensure this happens? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Remove Duplicates" | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"Turn "record macro" display on. | Excel Discussion (Misc queries) |