Hi,
Using LibreOffice 3.3.1 and am in the process of editing a 68000 row, 10
column file.
There are two main columns that contain the data to be cleaned up with
multiple instances of duplication i.e. the same text but only the text
case differs between two rows or the text is totally different
1) put into C1 formula =lower(a1)
2) sort te table on c column
3) put to d1 =0
4) put to d2 = if(c2=c1;1;0) and copy the formula to all rows in d column.
5) select d column, copy CTRL+C and paste special back as unformated text
6) rows with value 0 in d columns have duplicit value with the row
Hylton,
I can offer a few general considerations and thoughts. Your problem
statement appears to contain two objectives:
a) to make consistent the case of all the elements; all Upper Case; all
Lower Case; whatever. It seems the case makes no difference to the
meaning of the record. The
On 12/12/2011 10:33 AM, David S. Crampton wrote:
Hylton,
I can offer a few general considerations and thoughts. Your problem
statement appears to contain two objectives:
a) to make consistent the case of all the elements; all Upper Case;
all Lower Case; whatever. It seems the case makes
On 2011-12-12 09:39, Hylton Conacher (ZR1HPC) wrote:
Hi,
Using LibreOffice 3.3.1 and am in the process of editing a 68000 row, 10
column file.
There are two main columns that contain the data to be cleaned up with
multiple instances of duplication i.e. the same text but only the text
case