Hi Lars, On Mon, Apr 04, 2005 at 09:01:56 -0400, Lars D. Nood�n wrote:
> >1. Sort the rows. This may or may not be an option for you with the way > >your data is arranged. You might have to concatenate the data from > >multiple cells to get this to work. > >2. Use a filter. Data>Filter from the menu will get you to options for > >this. > [...] > > Sort is a step in the right direction, but does not seem to compress > duplicates down to a single row. > > I'm looking for the Calc equivalent of "sort x.csv | uniq > y.csv" or > "select distinct order by" in SQL. Use also the second step Steve provided (Data.Filter), and in the More options check "No duplication" and "Copy results to ..." and specify the upper left corner of the area where the output should go. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
