Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
looking for a formula that would work like a maxif
Thank you so much, that worked great.
So much still to learn. :) "Bernard Liengme" wrote: With the times in A, the numbers in B, and a time (such as 1:00) in D1 use =MAX(IF(A1:A6=D1,B1:B6)) This is an array function and must be entered with CTRL+SHIFT+ENTER not just Enter - Excel will enclose it in {} best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "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 | |||
How to do a MAXIF formula | Excel Worksheet Functions | |||
how can i check for #Value! ? ... or how do I do MaxIf?? | 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) | |||
maxif | Excel Worksheet Functions |