+ Reply to Thread
Results 1 to 3 of 3

Remove yelow cell whit formula is possible?

  1. #1
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Remove yelow cell whit formula is possible?

    hi my friend

    i use for statistics formula in row H and H

    i try more formula to remove result from yellow cell, but not find nothing correct..

    somebody know one shortcut?

    thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,858

    Re: Remove yelow cell whit formula is possible?

    In G3:

    =IFERROR(IF(LARGE($D$3:$D$78,ROWS($3:3))=0,"",LARGE($D$3:$D$78,ROWS($3:3))),"")

    In H3:

    =IF(G3="","",LOOKUP(2,1/SEARCH(G3,$D$3:$D$78),$C$3:$C$78))

    Excel 2016 (Windows) 32 bit
    G
    H
    3
    350
    excel power
    4
    250
    excel file
    5
    11
    power point
    6
    1
    love bite
    7
    8
    9
    10
    11
    Sheet: Sheet1
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: Remove yelow cell whit formula is possible?

    thanks AliGW, good thoughts..

+ 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] Set or put data in a cell whit choose in list
    By Yaghoub61 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-31-2020, 07:04 AM
  2. [SOLVED] A way to fill with yelow when cell is selected
    By JesusTello in forum Excel General
    Replies: 2
    Last Post: 05-03-2017, 07:26 PM
  3. bring text box whit Formula
    By musicbox1970 in forum Excel General
    Replies: 4
    Last Post: 03-27-2017, 07:38 PM
  4. [SOLVED] Formula whit INDEX and MATCH. I try to make this formula to result.
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2012, 06:26 PM
  5. Need help whit a graph
    By Steinar in forum Excel General
    Replies: 4
    Last Post: 06-20-2012, 06:51 AM
  6. Problem whit SUMIFS R1C1 Formula !
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 09:35 PM
  7. Problem whit formula VBA !
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2012, 11:09 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