How do I remove repeating data in an Excel database?
 

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?

How do I remove repeating data in an Excel database?
 

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

StacyL wrote:
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?

How do I remove repeating data in an Excel database?
 

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

"Die_Another_Day" wrote:

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

StacyL wrote:
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?