Hi! what command should i include in the SELECT query statement so that i can filter away the duplicate record(see only unique row)...eg by time. Thks!
.
Re: Engraved/Woodcut Effect ...filter or a way to duplicate this effect exactly. ... "The artist drawing an exact duplicate of herself on a mirror".... (alt.graphics.photoshop)
Unique item list still returns duplicates ... I have a list in Excel that contains records with duplicate numbers. ... am trying to filter this list via VBA to retrieve only unique records... The VBA code, which I found on ozgrid is listed below. ... (microsoft.public.excel.programming)
Re: Excel Spreadsheet Manipulation ... records before I execute the formula, how can I have 920 reocords AFTER I ... down to filter to another location. ...database and the post filtered database, they equal one another.....23,760 ... How do I eliminate duplicate addresses. ... (microsoft.public.excel.misc)
Re: Excel Spreadsheet Manipulation ... didn't apply the filter correctly or you had no duplicates. ... records before I execute the formula, how can I have 920 reocords AFTER I ...database and the post filtered database, they equal one another.....23,760 ... How do I eliminate duplicate addresses. ... (microsoft.public.excel.misc)
Re: Excel Spreadsheet Manipulation ... of the entries have been deleted once I do the Data - Filter - Advanced ... when I compare the number of entries on the pre-filtered ... check Unique Records only (and I prefer to select a different location ... And eliminate duplicate addresses and first name leaving only one last name ... (microsoft.public.excel.misc)
