Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

this formula works but suppose if there has 2 cells for One match 1 is Blank 1 is not blank then it's counting as inactive. I want if there are any match cell has blank cell then will whow "Active"

Add Answer
Wajed Hossain answered on July 5, 2023 Popularity 1/10 Helpfulness 1/10

Contents

  • answer this formula works but suppose if there has 2 cells for One match 1 is Blank 1 is not blank then it's counting as inactive. I want if there are any match cell has blank cell then will whow "Active"

    • More Related Answers

  • if cell is blank
  • excel return 1 if cell looks blank
  • Preserve numbers in cells where formulae exist. Otherwise you sometimes end with None as the cell content instead of the number if you were to open the spreadsheet

    • this formula works but suppose if there has 2 cells for One match 1 is Blank 1 is not blank then it's counting as inactive. I want if there are any match cell has blank cell then will whow "Active"

    Comment
    0
    Popularity 1/10 Helpfulness 1/10 Language whatever
    Source: chat.openai.com
    Tags: any cell cells counting formula match this whatever
    Link to this answer
    Share Copy Link
    Wajed Hossain
    Contributed on Jul 05 2023
    Wajed Hossain
    0 Answers  Avg Quality 2/10

    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.