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
