Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-16-2015, 05:21 AM
mbesspiata mbesspiata is offline How to get a MAX number to show in a stationary cell. Windows 7 64bit How to get a MAX number to show in a stationary cell. Office 2010 64bit
Advanced Beginner
How to get a MAX number to show in a stationary cell.
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get a MAX number to show in a stationary cell. 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
How to get a MAX number to show in a stationary cell. Formula in cell b1 using cell a1 if a1 is over certain number pumkinbug87 Excel 5 12-03-2013 12:34 PM
How to get a MAX number to show in a stationary cell. 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
How to get a MAX number to show in a stationary cell. photo as background or stationary jjfdds Outlook 2 12-31-2005 07:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft