+ Reply to Thread
Results 1 to 2 of 2

if a range of cell is empty then need the result ok,otherwise not ok

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    dhaka,bangladesh
    MS-Off Ver
    2007
    Posts
    12

    if a range of cell is empty then need the result ok,otherwise not ok

    hi
    i have below data,
    APP ISSUE W-SHADE(4 CLR)
    SUB DUE BLACK
    COM DUE WHITE
    APP RED & BLUE

    pls help to get result like below (file is also attached)

    WHEN
    APP ISSUE W-SHADE(4 CLR)=OK RESULT SHOULD BE LIKE THIS
    SUB DUE
    COM DUE
    APP RED & BLUE&BLACK&WHITE

    thanks
    Aripori
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: if a range of cell is empty then need the result ok,otherwise not ok

    I do not understand what you are trying to do. Can you please try to explain again.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show result Cell as Empty If.....
    By JRidge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 04:56 AM
  2. [SOLVED] Can a formula result in an 'empty' cell?
    By Cloth Ears in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-01-2014, 11:17 PM
  3. MACRO to empty a range of cells based on whether specified cell is empty
    By TBJV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 10:35 PM
  4. show empty cell if result is more than 20
    By fargobride in forum Excel General
    Replies: 4
    Last Post: 10-24-2009, 09:14 PM
  5. Macro to Find any empty cell within a range and show result in another column
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2008, 11:32 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