+ Reply to Thread
Results 1 to 4 of 4

Ignore blanks when using COUNTIF

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    edinburgh, uk
    Posts
    46

    Question Ignore blanks when using COUNTIF

    Hi guys,
    Need a little bit of help - i need to use this:
    =IF(OR(C4="",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB.")
    but i want to ignore blanks ... any ideas?

    Thanks in advance for your help

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Ignore blanks when using COUNTIF

    You mean:

    =IF(A4="", "", IF(OR(C4="",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB."))

  3. #3
    Registered User
    Join Date
    12-17-2008
    Location
    edinburgh, uk
    Posts
    46

    Re: Ignore blanks when using COUNTIF

    I dont want blanks to be either of these: "in CMDB" or "Not in CMDB"

    basically im comparing a two lists of IPs

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Ignore blanks when using COUNTIF

    This? =IF(OR(C4<>"",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB.")

+ Reply to Thread

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