=MIN(IF(($A$2:$A$8=A2)*($B$2:$B$8=B2)<0,$C$2:$C$8 ))
<ctrl<shift<enter 'array formula
Replace "=a2" and "=b2" with table of unique dates and rooms
"Hassan Alameh" wrote:
Hello everybody,
I have a data that is like this:
Date Room Time In
1 1 7:30 am
1 1 10:30 am
1 2 8:30 am
1 2 1:10 pm
2 1 8:30 am
2 1 6:40 am
2 1 9:45 pm
etc
can i have the minimum of every date AND room?, i.e. have a set of
minimums for each room and each room?
I am interested in knowing the starting times throughouth a month for
all rooms.
regards
|