| View previous topic :: View next topic |
| Author |
Message |
rjshen43
General User
Joined: 06 Aug 2011
Posts: 12
|
 Posted: Wed Feb 15, 2012 7:09 pm Post subject: [SOLVED]Which Function to use MAX and???? |
 |
|
Hello and Thanks:
In cells A1-A10 and C1-C10 are numbers. in cells B1-B10 and D1-D10 are times. In cell E10 I need a formula to find the max number in cells A1:A10 and C1:C10. In cell F10 I need the adjacent cell that has the max number. Say if A2 has the max number 21 and the cell next to it B2 has "0:12:23" then 21 should be returned in cell E10 and "0:12:23" should be returned in cell F10. 
Thank You
_________________
open office 3.2 on Ubuntu 10.10
Last edited by rjshen43 on Thu Feb 16, 2012 7:47 am; edited 1 time in total |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
Location: Sydney, Australia
|
| Posted: Wed Feb 15, 2012 7:21 pm Post subject: |
|
|
Try...
| Code: | | =MAX(A1:A10;C1:C10) |
in E10, and...
| Code: | | =IF(ISNUMBER(MATCH(E10;A1:A10;0));INDEX(B1:B10;MATCH(E10;A1:A10;0));INDEX(D1:D10;MATCH(E10;C1:C10;0))) |
in F10.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
rjshen43
General User
Joined: 06 Aug 2011
Posts: 12
|
| Posted: Thu Feb 16, 2012 7:48 am Post subject: |
|
|
Thanks works great!!!
_________________
open office 3.2 on Ubuntu 10.10 |
|
| Back to top |
|
|
|
