LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up repeating data in Excel Data repeat Excel Worksheet Functions 1 June 30th 08 05:28 PM
how do I remove repetitive cells in an excel database? jjr1975 Excel Discussion (Misc queries) 5 January 15th 08 04:27 AM
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row rjr Excel Programming 5 June 11th 06 09:43 PM
how do i remove multiple entries in an excel database? Chi Excel Discussion (Misc queries) 1 December 2nd 05 01:02 AM
How do I remove repeating rows automatically in excel? [email protected] Excel Programming 1 November 15th 05 02:18 AM


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"