I am looking for a formula please that will find the highest value from a number of cells within a column and put that highest value in another cell at the bottom of the column of figures. Alternatively, if I have a column with 10 values in it, I want to pick out the highest value from those 10 cells and put it in to another cell . Does anyone know of how I can achieve this please?
Last edited by VBA Noob; 03-03-2009 at 05:42 PM.
See MAX function
=MAX(range)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I knew it would be something as simple as that....just couldn't find it! Thank you for your help, very much appreciated and saves me a few more grey hairs!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks