+ Reply to Thread
Results 1 to 3 of 3

Filtering unwanted data

Hybrid View

marsc038 Filtering unwanted data 02-11-2014, 11:48 AM
Kaper Re: Filtering unwanted data 02-11-2014, 11:53 AM
marsc038 Re: Filtering unwanted data 02-11-2014, 11:59 AM
  1. #1
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,864

    Re: Filtering unwanted data

    in the first column next to your data write:
    =MOD(ROW(),10)=2
    copy down.
    autofilter and delete all rows with FALSEs
    if you do not have header row (or more than 1 header - change 2 into 1 or 3 or ...)
    Best Regards,

    Kaper

  2. #2
    Registered User
    Join Date
    02-11-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Filtering unwanted data

    Thanks very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete Unwanted Data
    By lweng in forum Excel General
    Replies: 10
    Last Post: 09-16-2010, 12:15 PM
  2. remove unwanted data
    By ahmedalhoseny in forum Excel General
    Replies: 1
    Last Post: 06-14-2010, 04:51 AM
  3. Filtering unwanted cells
    By gjonm in forum Excel General
    Replies: 4
    Last Post: 09-30-2009, 10:00 AM
  4. Getting rid of unwanted data
    By chedges in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2009, 06:18 AM
  5. Filtering out unwanted duplicate records
    By troydk in forum Excel General
    Replies: 4
    Last Post: 09-04-2008, 07:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1