Re: [libreoffice-users] [3.5.1.2/Calc/XP] Keep unique rows?

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: users+help@global.libreoffice.org
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