Min, Max
Hi Jonz,
Am Sat, 14 Jul 2012 09:29:30 +0000 schrieb jonz erazol:
How to get the min and the max in this table base on the names on column
A and time on column B.
Column A Column B
James 7:00 AM
James 8:55 AM
James 5:30 PM
Cameron 7:00 AM
Cameron 5:15 PM
George 8:56 AM
George 9:30 AM
George 11:00AM
George 2:59 PM
try:
=MIN(WENN(A1:A100="Cameron";B1:B100))
and
=MAX(WENN(A1:A100="Cameron";B1:B100))
enter both formulas with CTRL+Shift+Enter
Or try it with Pivot-Table - drag names into rows and time two times to
values and choose for time max and min
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|