Results 1 to 6 of 6

extract specific values from list

Threaded View

mcm1009 extract specific values from... 10-15-2010, 03:33 PM
jeffreybrown Re: extract specific values... 10-15-2010, 03:40 PM
zbor Re: extract specific values... 10-15-2010, 03:47 PM
MarvinP Re: extract specific values... 10-15-2010, 03:51 PM
mcm1009 Re: extract specific values... 10-15-2010, 04:29 PM
mcm1009 Re: extract specific values... 10-15-2010, 04:50 PM
  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Morrison, Colorado
    MS-Off Ver
    Excel 2016
    Posts
    10

    extract specific values from list

    Hi, I've got a list of numerical values ranging from 1 to 111, in random order. What I need done is to create another list from the original list, but have it exclude any value over 100.

    Current List

    2
    56
    33
    108
    12
    18
    101
    78

    Need a new list in a different column that only shows the values under 100. This new list cannot have any blank cells in between the remaining numbers.

    2
    56
    33
    12
    18
    78

    I know an advanced filter can do something similar to this, but the issue for me is that the list of original numbers cannot have a header on it. The list I am trying to extract from is actually on the end of a much longer list.

    Can this be done with just a formula and without VB? Thanks.
    Last edited by mcm1009; 10-15-2010 at 03:39 PM. Reason: add additional info.

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