+ Reply to Thread
Results 1 to 4 of 4

use formula to display only if under certain word else is blank

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    use formula to display only if under certain word else is blank

    hi, attached is a sample book, but on sheet 2, column B, i would like to display only if 'QUOTE' sheet displays 'MISC' on the cell.
    so basically, if its shows 'MISC' (on QUOTE SHEET) , to display on the sheet2 to on all the columns A, B, C, D. else just stays blank.
    could someone help me please.
    what i have in the cell formula is this: =IF(QUOTE!A1>0,QUOTE!A1," ")
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: use formula to display only if under certain word else is blank

    Maybe try

    =IF(QUOTE!$A1="Misc",QUOTE!A1,"")

    or
    =IFERROR(INDEX(QUOTE!A$1:A$8,AGGREGATE(15,6,ROW(QUOTE!$A$1:$A$8)/(QUOTE!$A$1:$A$8="Misc"),ROWS(E$1:E1))),"")
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    845

    Re: use formula to display only if under certain word else is blank

    Hi there,

    You may try in cell A1 of sheet 2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then pull down and across.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  4. #4
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    Re: use formula to display only if under certain word else is blank

    thank you Bo_ry and ORoss, it works!

+ 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] 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
  2. [SOLVED] Formula to display blank if 2 cells are blank
    By bdouglas1011 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2014, 08:47 AM
  3. [SOLVED] Modify a Formula to Display Blank
    By Barb Reinhardt in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 03:05 PM
  4. [SOLVED] Modify a Formula to Display Blank
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. Modify a Formula to Display Blank
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] Modify a Formula to Display Blank
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] would like to know the formula amount and display word
    By sarah in forum Excel General
    Replies: 1
    Last Post: 06-24-2005, 04:05 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