Re: Using Min & Max to sort log times.
- From: "Max" <demechanik@xxxxxxxxx>
- Date: Fri, 15 Feb 2008 11:37:02 +0800
Assume data is in row 2 to 100 in cols A to C as posted
In D2, array-enter ie press CTRL+SHIFT+ENTER:
=IF(COUNTA(A2:B2)<2,"",IF(SUMPRODUCT((A$2:A2=A2)*(B$2:B2=B2))>1,"",MIN(IF((A$2:A$100=A2)*(B$2:B$100=B2)*(C$2:C$100>0),C$2:C$100))))
In E2, array-enter ie press CTRL+SHIFT+ENTER:
=IF(COUNTA(A2:B2)<2,"",IF(SUMPRODUCT((A$2:A2=A2)*(B$2:B2=B2))>1,"",MAX(IF((A$2:A$100=A2)*(B$2:B$100=B2)*(C$2:C$100>0),C$2:C$100))))
Then select D2:E2, copy down to row100.
Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"J.W. Aldridge" <jeremy.w.aldridge@xxxxxxxxx> wrote in message
news:cb388363-1857-4846-bec7-aa9806bf171f@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a list of data that I am trying to get my peoples actual
production time down.
I have their names in A, Dates in B, Times they moved work in C.
I need to know the time they started working to the last time logged
(min time value vs. the max time value in column C) for each name &
date in A.
D = the min time for Joe, then Amy
E= the max time logged for each.
A B C D E
JOE 2/14 3:01 3:01 3:15
JOE 2/14 3:15
JOE 2/14 3:30
AMY 2/14 3:31 3:31 4:15
AMY 2/14 4:00
AMY 2/14 4:15
Any ideas or suggestions???
.
- Follow-Ups:
- Re: Using Min & Max to sort log times.
- From: Max
- Re: Using Min & Max to sort log times.
- References:
- Using Min & Max to sort log times.
- From: J.W. Aldridge
- Using Min & Max to sort log times.
- Prev by Date: Re: Start up error
- Next by Date: Re: alphabetize within a cell
- Previous by thread: Using Min & Max to sort log times.
- Next by thread: Re: Using Min & Max to sort log times.
- Index(es):
Relevant Pages
|
