Finding the Max Number
Not sure if I'm having one of those days already but, I want to find out to show the Max number between a set of different cells.
I have a report which show different information. I want to take certain cells and find out what the max number would be...
An example of where they are set out is
I thought =MAX(C12,F12 and so on would work but I end up with error
Where I gone wrong?
Are you using VBA for this because you have posted in the Programming Forum?
Works for me OK up to a maximum of 30 individual ranges?
Error values or text that cannot be translated into numbers cause errors
Moved to more suitable Forum
Apologies, wasnt thinking when posted...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By all4excel in forum Excel Formulas & Functions
Last Post: 01-05-2008, 04:06 PM
By ind in forum Excel General
Last Post: 06-13-2007, 12:24 AM
By mkron in forum Excel General
Last Post: 01-28-2007, 12:13 AM
By mikesimmo in forum Excel Programming / VBA / Macros
Last Post: 01-25-2007, 03:15 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1