In Calc select Data>Filter>Advanced Filter... Then expand the "More" drop down menu. Click the "No duplication" checkbox. You will get a single instance of every entry in your original column.
Tom K On Sep 5, 2011, at 5:39 PM, Bob Marcus wrote: > 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
