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
