Re: how to de-duplicate.
Andrew Douglas Pitonyak <[email protected]>
| Newsgroups | gmane.comp.openoffice.questions |
|---|---|
| Message-ID | <[email protected]> |
Because this is a one time thing, I would take the fastest path to success. This is a bit cumbersome, but, you did say that you only needed to do this ONCE! * Place the data of interest in column A * Sort Column A. With the options, you can turn case sensitivity on and off, etc. Probably do not need to do this, but hey.... * If it is not there already, add a column header. I used "Names". * Select the data including the column header * Use DAta > DAta Pilot > STart * For "Source", use "current selection", which is what should be marked already, and click OK * I have this strange dialog now, and there is "Name", the column heading", shown next to the buttons. Drag "Name" into the "Row Fields" area. * Click OK. You just created a Data Pilot, that is probably at the bottom of your data. The rows are the unique values for that column. You can copy those as you desire I believe. I have other methods as well, but, this is probably the most interesting method. On 09/05/2011 06: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 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help