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.
oldgnome
Lars D. Nood�n said the following:
I'm looking for a way to cull duplicate rows from a pair of columns in Calc, leaving just a set of unique rows. e.g.
AA BB AA AA BB BB AA BB AA AA
becomes
AA BB AA AA BB BB
Any suggestions on how to do this or where to look for ideas?
-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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
