How to take repeating items out of a list on microsoft excel or microsoft word?

So say I have a list.


eggs


ham


ham


eggs


ham


cheese


I dont know you got the idea right? And its either in the cells of microsoft excel or just in word. Is there any way to not manually remove the repeating items? I know i could sort it, but is there any function that would get rid of the repeating words? and if not on microsoft, are their any other websites, or ....programs that will?

How to take repeating items out of a list on microsoft excel or microsoft word?
This works in Excel 2000 and can give you the idea.


Name the list eg "Food"


Similarly to "expletiv" instructions for Excel 2003 however


a) You can select the whole colum including blanks as this is easier (click the colum letter at the top).


b) after the Data%26gt; Filter%26gt; advanced filter, select "copy to another location"


c) you only need to put the top cell of the target (copy to) location


d) leave criteria blank


e) List range should already contain the address of your list of foods


f) only after selection of 'unique records only' and all of the above you then press "ok"





Your list will appear at the target location with no duplicates and in the original order.
Reply:this is 1 easy way





if you are using excel 2003


- highlight your column (1st entry to last entry)


- Click Data (top menu)


- Click Filter


- choose advanced filter


- if excel cant determine a header...thats cool...hit OK


- put a checkmark next to "unique records only


- click ok


- this will only HIDE the duplicates


- you have to copy


- choose an empty sheet or an empty part of the sheet (make sure nothings hidden)


- then paste it





that should do it.
Reply:While I do not know of software specific and I am sure something exists, I use one of these two approaches.


1) I do a sort on the column that contains the repeating data, Highlight all of the identical cells (since they would be together) than select merge, than immediately unmerge them (Note unmerge vice undo).


or


2)I do a find and replace with the replace field being blank.
Reply:It seems You need a List of Unique Values


You can click menu Data %26gt; Filter %26gt; Advanced Filter


box "Criteria" = (none)


checkBox "Unique Records Only" = Checked


box "copy to another location" = Select a cell.





or


you can write an Array Formula


=OFFSET($B$10;MATCH(SUM(COUNTIF($B$11:...


where:


B11:B20 = your data


D11 = first cell the result will be displayed


D12 and so on, copy of formula in D11, until result = #NUM! error