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
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
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 350excel power 4 250excel file 5 11power point 6 1love 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.
thanks AliGW, good thoughts..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks