Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for a formula that would work like MAXIF
or this in the first row, copied down
=MAX(IF($F$2:$F$10=TIME(ROW(),0,0),$G$2:$G$10)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Nicholas" wrote in message ... I have Excel 2003, that I am trying to find the max number for a certain set of time. Time,Count 1:00,14 2:00,15 3:00,20 1:00,7 2:00,8 3:00,10 etc.. I need to know what is the max value for 1:00, 2:00, 3:00,etc. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for a formula that would work like MAXIF | Excel Discussion (Misc queries) | |||
looking for a formula that would work like a maxif | Excel Discussion (Misc queries) | |||
How to do a MAXIF formula | Excel Worksheet Functions | |||
A formula maxif, similar with sumif or countif | Excel Worksheet Functions | |||
Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) |