How do I remove repeating data in an Excel database?

S

StacyL

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?
 
D

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
 
S

StacyL

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top