How to Remove Duplicate Rows in Calc [OOo, LibreOffice & NeoOffice]

There is no automatic function to remove duplicate rows in Calc. In order to remove duplicate rows you need to perform some comparison tests. This tutorial will show you how to sort the data compare the data remove the duplicate rows There is a tutorial here that will show you how to check for duplicates on a single column value, however often we need to compare for more than one value … [Read more...]

FAQ: How to sort lists in OpenOffice.org Calc

I addressed sorting in OpenOffice Writer in a previous post, and have since had a request for a tutorial on sorting in Calc, so here it goes. Step 1 Select the entire data range that you want to sort. This includes all the columns that have data that need to be kept in line with the column that you want to sort. Include the headers of the column as well, as OpenOffice will pick these up as … [Read more...]