Results 1 to 4 of 4

Formula to display blank if a cell is blank and to display text if value does not match

Threaded View

  1. 08-22-2021, 08:32 AM #1
    dlealb
    dlealb is offline
    Registered User
    Join Date
    04-09-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office Standard 2013
    Posts
    82

    Formula to display blank if a cell is blank and to display text if value does not match

    Im trying to compare 2 masterlist and apply the changes to a company software
    need help to identify which is to be added and which is to be remove
    i was able to get to the part where it displays add and remove my delimma is when there is a blank on either cells under sups and oms

    Attached is a sample
    Please assume some cells under sups and managers are empty for the last part

    Any help is much appreciated
    Attached Files Attached Files
    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)

Similar Threads

  1. [SOLVED] Trying to display blank cells as blank, rather than 0% with INDEX and MATCH
    By davo3286 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2020, 07:11 AM
  2. [SOLVED] Need help making COUNTIFS formula display as blank if it's 'criteria cell' is blank
    By 27POP27 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2018, 07:38 AM
  3. Display blank cell if previous cell is blank in formula
    By Brent951 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-29-2016, 03:34 PM
  4. formula to determine which cell is NOT blank and display that cell's text?
    By LWSheehan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2015, 08:54 PM
  5. VBA - Check 3 rows if blank and display text in one of them in adjacent cell
    By guitalex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2012, 09:32 AM
  6. Re: Conditional display - IF cell is blank, display next used row!
    By Patti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2006, 05:35 PM
  7. how to get excel to display blank if reference cell blank
    By silent1(not) in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2005, 10:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1