Results 1 to 11 of 11

Ignore Blank Values While Using INDEX

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2014
    Location
    TN
    MS-Off Ver
    Excel 2003
    Posts
    7

    Ignore Blank Values While Using INDEX

    I have found several answers to this, but I haven't had much luck with most of the solutions I've seen, usually revolving around IFBLANK. I feel like I am probably just not getting it - sorry!

    I have this formula:
    =INDEX($Q$2:$Q$546,MATCH(0,INDEX(COUNTIF($U$1:U1,$Q$2:$Q$546),0,0),0))
    The intent is for it to scan Q2:Q546 to create a unique list in U2:U547.

    Q2:Q546 is a work column that pulls text values from other sheets in the workbook via simple cell references.

    The problem is, in the reference cells (and thus Q2:Q546), there are a lot of blank cells, and the first blank always inserts a '0' or blank cell into the list, located at the place the first blank cell happens. It would be preferable to not have this blank cell (or, alternatively, just sort the blank cell to the bottom?)

    Like I said, my fault, the answer is here on the forums, I am just not grokking it - any help is appreciated as always!
    Last edited by jokorey; 04-08-2014 at 01:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Ignore If Blank & check multiple cells for equal values
    By Urugmo88 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-25-2013, 04:46 AM
  2. [SOLVED] An INDEX MATCH formula has blank cell - need to ignore or delete
    By rls231 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2013, 11:13 PM
  3. Replies: 4
    Last Post: 07-18-2012, 02:34 PM
  4. Line chart should ignore blank data values
    By kenelder in forum Excel General
    Replies: 2
    Last Post: 06-10-2011, 03:50 AM
  5. Array Function - ignore blank values
    By gillemi in forum Excel General
    Replies: 6
    Last Post: 06-13-2006, 04:10 AM

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