+ Reply to Thread
Results 1 to 2 of 2

Extract values from a range based on a single criteria and display in a single list

  1. #1
    Registered User
    Join Date
    11-09-2014
    Location
    London, England
    MS-Off Ver
    Office 2013
    Posts
    1

    Extract values from a range based on a single criteria and display in a single list

    I want to extract all the values from a range of cells (multiple columns and rows) in a table that meet a certain criteria (length) and list them in a single column in a different table. I started using an INDEX SMALL IF ROW function which I have used previously for other things, but it didn't work because there is not a specific column that I want to look up - it is a whole range.

    e.g.

    Data Set

    Name

    AAAAAAA Short 1 Long 1 Short 2 Long 2 Short 3 Long 3
    BBBBBBB Short 4 Long 5 Short 5 Short 6 Long 6 Short 7 Long 7
    CCCCCCC Long 8 Short 8 Short 9 Long 9 Short 10 Long 10
    DDDDDD Short 11 Long 11 Short 12 Short 13 Long 12 Short 14 Long 13

    I want to return a list like this, based on the length of the text in the range:

    Long 1
    Long 2
    Long 3
    Long 4
    Long 5
    Long 6
    Long 7
    Long 8
    Long 9
    Long 10
    Long 11
    Long 12
    Long 13

    Any ideas? All help very much appreciated!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Extract values from a range based on a single criteria and display in a single list

    try this code:

    Please Login or Register  to view this content.

+ 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] Display a dropdown list or populate a cell with single value based on other cells' values
    By filla_dilla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 09:47 AM
  2. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  3. Replies: 1
    Last Post: 09-20-2012, 05:32 AM
  4. Replies: 7
    Last Post: 03-29-2012, 01:25 PM
  5. Replies: 1
    Last Post: 05-31-2011, 02:08 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