| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Largest Value
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 |
|
#2
|
|||
|
|||
|
If you put =MAX(previous 12 cells) in the 13th cell, you should get the largest value. Is that what you want? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=380572 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
exactly, I knew it had to be rather simple but didn't know the command. -- o5prey ------------------------------------------------------------------------ o5prey's Profile: http://www.excelforum.com/member.php...o&userid=23446 View this thread: http://www.excelforum.com/showthread...hreadid=380572 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| 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) | |||
Linear Mode
