Thread: How to get a MAX number to show in a stationary cell.
View Single Post
 
Old 06-16-2015, 05:21 AM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default How to get a MAX number to show in a stationary cell.
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
Reply With Quote