how to de-duplicate.
"Bob Marcus" <[email protected]>
| Newsgroups | gmane.comp.openoffice.questions |
|---|---|
| Message-ID | <2B74D24D487E4C0FB2469B8BDBF35C2A@It> |
I’m relatively new to ooS, but I am not finding a key word in the usual Help. I have a single column on a spreadsheet with some 8000 entries. Many of the entries are duplicate words, some with variations on capitalizations. I want to relist that one column to show only a single entry for each word. That is, I want to consolidate the entries so that I have only one entry for each of the words in the column. Again, that is if I have the word ‘metal’ listed 10 times, I want a new list with that word, ‘metal’, only once. I see that there are pro programs to buy but my use is one time and I think I remember that there is some formula. Thanks for any advice. Bob M-- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help