![]() |
|
#1
|
|||
|
|||
|
I have daily totals of items accomplished in column B of my spreadsheet and accepted in column C. I use the following formula to show the highest of each in column F, =IF(C2=MAX($C:$C),"HIGHEST # ACCEPTED",IF(B2=MAX($B:$B),"HIGHEST # ACCOMPLISHED"," "))
My question is how can I get those to show up in a cell towards the top of my sheet in a stationary position that would update when those highs change? Right now the "HIGHEST # ACCEPTED AND ACCOMPLISHED" show up in column F just across from where that highest number is located. Is this possible at all? Mike
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Entering a number in a cell causes it to fill with the color of a nearby cell
|
Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
show a cell
|
s7y | Excel Programming | 26 | 05-26-2012 08:00 PM |
| Can not access signatures or stationary/fonts | ytram1949 | Outlook | 0 | 01-15-2011 08:29 AM |
photo as background or stationary
|
jjfdds | Outlook | 2 | 12-31-2005 07:20 AM |