Results 1 to 2 of 2

Thread: ignore #num when no data

  1. #1

    ignore #num when no data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I have the below array formula which works fine until it picks up no data when it displays #num error. Is ther any way I can add someting in this formula not to show #num.

    Thanks.

    =INDEX(DB!$M$2:$M$24077, SMALL(IF($A$1=DB!$B$2:$B$24077,ROW(DB!$B$2:$B$24077)-ROW(DB!$B$2)+1),ROW(DB!1:1)))

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    You could use an =IF(isnumber(cell to check), your current formula, "")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •