![]() |
#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 ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
![]() |
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
![]() |
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 |
![]() |
jjfdds | Outlook | 2 | 12-31-2005 07:20 AM |