+ Reply to Thread
Results 1 to 2 of 2

how to select rows after particular difference in value

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    how to select rows after particular difference in value

    Hi to all,
    I have data like this in my big excel file
    Item value
    A 10
    B 10.5
    C 13
    D 14
    E 14.5
    F 15
    G 16
    H 16.5
    I 17
    J 17.8
    K 18
    L 19
    M 20
    N 21
    O 21.5
    P 22
    Q 22.5
    R 23
    S 24
    T 25
    U 26
    V 27
    W 28
    X 29
    Y 30
    Z 31
    Now i want to select Item list after every difference of 5 in value column. I am expecting data like this
    EXPECTED
    ITEM VALUE
    A 10
    F 15
    M 20
    T 25
    Y 30
    I have huge data file can any one help me to solve this problem. Iam attaching sample file for better understanding.
    Any help would be highly appreciated
    Thanking you very much,
    Genetist
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: how to select rows after particular difference in value

    Hi Genetist,
    look at the option of the auxiliary column and AutoFilter

+ 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. [SOLVED] Code That Allows User to Select Two Cells and Get the Difference as an Output
    By jbwitty in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-08-2012, 05:20 PM
  2. Code to prevent user to Select COLUMNS but allow to select ROWS
    By tengrosita in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 03:46 AM
  3. is there a difference between Select Case and If..Then
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-19-2009, 11:20 AM
  4. what's the difference between Activate and Select for Worksheet?
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2005, 01:05 PM
  5. I want to select excel cells of difference colors and increase th.
    By Wilbanks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2005, 10:25 PM

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