How do I remove repeating data in an Excel database?

[Guest]

How can I remove repeated data in a filtered Excel database? Example: In a
spreadsheet I have Goals, Objectives and Staff Action. Each goal, objective,
and staff action was entered into it's own row. I can filter for Goal #1,
but some of the objectives repeat and the spreadsheet is 50 pages long. I
want to stop information from repeating. How can I do this without going
through the spreadsheet and pressing delete?

 

[Die_Another_Day]

Try using the Advanced Filter, Unique Items, then Copy and paste. Post
back if you need a macro to do this, or if you need more assitance.

Charles Chickering

 

[Guest]

That will not work. Here's an example of the text typed into this email...

Goal Objective Staff Action
PIO Public Outreach Report
PIO Public Research Report
PIO Public Survey Survey

I need the first PIO to remain and the repeated PIO to disappear for a
cleaner look. I need all the objectives to stay since they are different. I
need the second report to disappear, but the first report to stay. A cleaner
look would be the following example if I could figure this out without having
to use the delete key. This is a weekly changing document.

Goal Objective Staff Action
PIO Public Outreach Report
Public Research
Public Survey Survey