Hi Gilles,
Gilles schrieb:
Hello
I'm going through a log file with a lot of duplicates, eg.
-----------------
ReadFile C:\$Directory
ReadFile C:\$Directory
ReadFile C:\Documents and Settings\Fred\Local Settings\Application
Data\Microsoft\FORMS\FRMCACHE.DAT
ReadFile C:\Documents and Settings\Fred\Local Settings\Application
Data\Microsoft\FORMS\FRMCACHE.DAT
etc.
-----------------
Is there a tool for Calc that would go through the sheet and only keep
unique rows?
You can try to use the filter.
Mark all rows.
Data > Filter > Standard Filter
Open the 'More Options' section
Adjust 'Range contains column labels' to your selection.
Mark 'Copy results to' and enter the address of the left/top cell of the
target range.
! Mark 'No duplication'
In the upper part you can use the filter criteria "=" "-not empty -" for
the relevant columns.
Kind regards
Regina
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
