Results 1 to 11 of 11

IF cells in a range are empty, reference values in another cell range

Threaded View

  1. #6
    Registered User
    Join Date
    01-13-2021
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel O365 Enterprise
    Posts
    10
    The OFFSET is required to filter against different variables in other circumstances.

    Correction, answer = 3. Rows 11, 12, 13 where:

    Row 11: Variable = "X", Test 2 result = empty, therefore this row specifically relies on the empty cell condition, where Test 2 is empty, the formula needs to alternatively revert to test the result in the Test 1 range which in this instance contains the required “A” result
    Row 12: Variable = "X" / Test 2 result = "A"
    Row 13: Variable = "X" / Test 2 result = "A"

    Rows that don't meet the criteria:
    Row 14: Variable = "X" / Test 2 result = empty / Test 1 result = "B"
    Row 15: Variable = "C" / Test 2 result = "A"
    Row 16: Variable = "X" / Test 2 result = "C"
    Last edited by KJ_; 01-13-2021 at 06:21 PM. Reason: Miscalculation

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] count values in one range if the cells in a corresponding range are not empty
    By Thurgel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-09-2020, 10:22 AM
  2. [SOLVED] How to create a dynamic range if the last cell is empty and the columns have empty cells
    By peter_swe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2016, 11:18 PM
  3. Replies: 0
    Last Post: 08-03-2016, 07:01 PM
  4. Replies: 5
    Last Post: 08-21-2014, 09:10 AM
  5. [SOLVED] Transfer cells range to another sheet if first cell of destination range is empty
    By kopapa in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-04-2013, 04:32 PM
  6. If the range A1:F1 and the cell H1 are not empty, then all range cells must be not em
    By loroverde in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2013, 04:13 AM
  7. 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

Tags for this Thread

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