+ Reply to Thread
Results 1 to 3 of 3

Filtering unwanted data

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

    Filtering unwanted data

    Hello,

    I'm using a data logging software and accidentally set the sample rate to 100milliseconds as opposed to 1 second, as a result I have an excessively large data set to analyse in excel and was hoping to remove all data points between each second.

    Here is an example
    time (ms) temperature
    14000 19.13
    14100 19.14
    14200 19.14
    14300 19.14
    14400 19.14
    14500 19.15
    14600 19.15
    14700 19.15
    14800 19.15
    14900 19.15
    15000 19.15

    I wish to remove all points between 14000 and 15000 so that I can rewrite this data in the form

    time (s) Temperature
    14 19.13
    15 19.15

    Any assistance is greatly appreciated
    Thanks

  2. #2
    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,607

    Re: Filtering unwanted data

    in the first column next to your data write:
    Please Login or Register  to view this content.
    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

  3. #3
    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