Results 1 to 6 of 6

Iferror, index, array...

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Iferror, index, array...

    Hello,

    Please see attached.

    On Sheet 2014, Column K, there are blank cells and non-blank cells.

    On Sheet Driver Summary, Columm B, I would like the date, Column B, of all the non-blank cells found in Column K. Any Blank cells in Column K would be ignored.

    Please let me know if this is unclear as i'm not sure how to write the logic for this but i do know that it's an array, index and iferror formula involved....

    Thank you in advance!

    Jason
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Iferror, index & match
    By meh999 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-26-2014, 08:43 AM
  2. VBA - Index formula to be combined using IFERROR
    By gan_xl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2014, 06:15 AM
  3. Help with Formula Please!! (IFERROR/INDEX)
    By leowyatt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2013, 04:28 AM
  4. =IFERROR(INDEX - formula not working
    By tcrjmom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2013, 01:29 PM
  5. Looking for better formula of iferror, index and match
    By DavidRoger in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2012, 07:50 AM

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