what this part does is test the whole range to be the date of the current
row, and returns only values where those dates match. This way, on a row
where the date is 01/01/2005, it builds an array of values associated with
that date, and ignores the values associted with other dates. MIN then works
on this array to extarct the MIN value for that date.
--
HTH
Bob Phillips
"Sho" wrote in message
...
That is exactly what I wanted. What I do not understand is how it is
calculating it? Could you explain how the formula is calculating e.g. how
does IF($A$1:$A$100=A1,$B$1:$B$100) work out that if the date is the same
it
finds the minimum time?
"Sho" wrote:
Can anyone help with the following;
I have dates in column B e.g. 01/05/05 (could be lots of dates on the
same
day or different days) and times in Column C e.g. 0900,1545 (all 24hour
clock) I want to be able to do a formula that says;
If the time in cell C1 is the first time after 0800 on the same date if
it
appears in column B, then I want to see the result of 1 appear in D1.
e.g.
Column B Column C Column D
01/05/05 1045
01/05/05 0930 1
01/05/05 1517
02/05/05 1120 1
02/05/05 1640
Any help would be great!
|