Results 1 to 9 of 9

Edit formula not to consider blank cells with formulas

Threaded View

  1. 03-25-2021, 07:11 AM #5
    aswethink
    aswethink is offline
    Registered User
    Join Date
    02-21-2021
    Location
    Manila
    MS-Off Ver
    O365 16:61
    Posts
    54

    Re: Edit formula not to consider blank cells with formulas

    Sheet1 displays the formula working in D3.
    Sheet2 displays the problem. The formula works but is also including blank cells in its assessment of U3:Z7.

    U3:Z7 in Sheet1 do not have formulas.
    U3:Z7 in Sheet2 contain formulas.

    I would like to edit the formula in D3 of Sheet2 to display the same results as those found in column L:L of Sheet1.
    Attached Files Attached Files
    Last edited by aswethink; 03-25-2021 at 09:18 AM.
    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] Formula to show 'Reject' number and type
    By chuttus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2018, 08:18 PM
  2. [SOLVED] formula to define accept/reject for testings of some product with diffrent spec.
    By Pt.purba in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-18-2017, 01:14 PM
  3. [SOLVED] Array formula which compares values, ignores blanks, and results in a single accept/reject
    By bearwldr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2015, 06:12 AM
  4. [SOLVED] Formula to calculate Complete's and Reject's
    By rajeshntiwari in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2014, 06:57 PM
  5. [SOLVED] Formula that will count names but reject the word BLOCKED
    By armynurse in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 06:20 PM
  6. [SOLVED] Reject Manual Input
    By SMERTZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2006, 10:30 AM
  7. [SOLVED] Disable Accept/Reject Changes
    By tjtjjtjt in forum Excel General
    Replies: 0
    Last Post: 04-20-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1