| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
LOL
=MAX(A1:A12) -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... Hi Ron, That's only 10 cells <vbg Bob "Ron de Bruin" wrote in message ... Use this function =MAX(A1:A10) -- Regards Ron de Bruin http://www.rondebruin.nl "o5prey" wrote in message ... Is there a simple way to compare the values in 12 cells, and then return the largest value in the 13th cell. I could do this with a complex AND, OR series but there has to be a simpler way. -- o5prey ------------------------------------------------------------------------ o5prey's Profile: http://www.excelforum.com/member.php...o&userid=23446 View this thread: http://www.excelforum.com/showthread...hreadid=380572 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) | |||
| Second largest value | Excel Discussion (Misc queries) | |||
| finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
| Getting the 2nd largest or smallest valuesin a range | Excel Discussion (Misc queries) | |||
| Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
Threaded Mode
