On Mon, 4 Apr 2005, Steve Kopischke 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.
-Lars
Lars Nooden ([EMAIL PROTECTED])
Software patents harm all Net-based business, write your MEP:
http://wwwdb.europarl.eu.int/ep6/owa/p_meps2.repartition?ilg=EN
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
