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

Hi Gilles,

Gilles schrieb:
> Thanks Regina, but after filling the form thusly...
>
> http://img692.imageshack.us/img692/3632/libreofficecalcremovingo.jpg
>
> ... nothing happens: Did I do something wrong?

Try to chose a cell on a different sheet for the output. You can 
minimize the dialog by the button next to the input field to click on 
the target cell. Select all data. It will drop those rows, which are 
totally identical.

Or

If you do not want to copy the data, then uncheck "Copy results to". 
Select only those columns which you want as criteria for "double". The 
double rows are hidden. Hiding effects the whole row.

In the drop-down list of 'value' chose the item "- not empty -".

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