+ Reply to Thread
Results 1 to 2 of 2

Filtering range of data points

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    U.S.A.
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Filtering range of data points

    hello all, i have a set of data points similar to the table below

    Distance Elevation
    0 km 350 m
    17 km 355 m
    21 km 366 m
    30 km 375 m
    45 km 370 m
    55 km 340 m
    60 km 355 m

    the table that i have has a total of 48000 rows and i have to select 1000 among them. Can any body let me know a way to do that. i want to select the rows whose elevation is beyond the range of +/- 5 m from the elevation of the previous row. as an example i need to get the following table from the table from above

    Distance Elevation
    0 km 350 m
    21 km 366 m
    30 km 375 m
    55 km 340 m
    60 km 355 m

    a quick respose is greatly appreciated

    Deep

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Filtering range of data points

    Hey Deep;

    I have a formula you can use, however, the first and last rows won't really work:

    So, starting on Row 2 of the data:

    =IF(OR(ABS(B2-B1)<=5,ABS(B2-B3)<=5),"Within 5","Greater than 5")

    Then you can throw a filter on the column that contains that text, and select those that are only greater than 5 to obtain your 1000 records.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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