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