Results 1 to 26 of 26

Show cell as empty if referenced one is empty

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Wales, UK
    MS-Off Ver
    365 (Mac)
    Posts
    191

    Show cell as empty if referenced one is empty

    Hi,

    Re the worksheet (in the image), I have the following formula in B4, which works perfectly - when there's data.

    =LET(u,IFERROR(UNIQUE(FILTER('All Completed Runs'!D4:D357,('All Completed Runs'!E4:E357<>"")*('All Completed Runs'!D4:D357<>"UK Crown Dependencies & UK Overseas Territories"))),""),c,COUNTIF('All Completed Runs'!D:D,u),SORTBY(HSTACK(u,c),c,-1))
    However, when there isn't data in A4 and/or B4 I would like the count column (C) to also appear empty. I have tried adding various if(A4="","", type things into it, in various places, but nothing seems to work - they all mess up the LET formula. Is there something I can do to achieve this?

    Thanks in advance!

    Olly.

    Also posted on MREXCEL.COM: https://www.mrexcel.com/board/thread...empty.1254622/IMG_7258.jpeg
    Last edited by ollyhughes1982; 02-26-2024 at 04:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to set referenced cell to empty instead of zero.
    By paata01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2023, 09:36 PM
  2. [SOLVED] Not empty cells to adopt 'interior.color' of referenced cell
    By sirruckus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2021, 09:24 AM
  3. [SOLVED] Check if referenced cell is empty on a specific date
    By streakotter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2018, 07:22 AM
  4. Show cell empty if result is an error due to empty source
    By jackmcguigan1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2016, 09:54 AM
  5. [SOLVED] If cell is empty = show nothing
    By mack4n in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-29-2015, 02:29 AM
  6. [SOLVED] excel 2010 empty a cell according to other cells (without Deleting them just show empty)
    By pavlos_x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 01:46 PM
  7. Reference cell is empty but when referenced gives me value of 12:00 am
    By nhopkins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2013, 05:02 PM

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