Results 1 to 3 of 3

Formula to display whether a text data is present or not in a column

Threaded View

  1. 06-10-2009, 08:00 PM #1
    shuresh
    shuresh is offline
    Registered User
    Join Date
    12-03-2008
    Location
    Bangalore
    Posts
    3

    Formula to display whether a text data is present or not in a column

    I need help on which formula to use for the following query!

    If I have some short messages in cell number 1 and 3 of column A and cell number 2 and 4 are empty. I need a formula which gives a result as 1 when there is a message and 0 for no text message in column B. Thanks in advance.

    Eg
    A B
    Hello 1
    0
    Nice 1
    0
    Last edited by shuresh; 06-11-2009 at 06:47 PM. Reason: Not complying with the forum rules
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1