On Sat, 14 Jul 2012 09:29:30 +0000, jonz erazol wrote:


Good day...
Im just new in using ms excel 2007.
Please help me this scenario.

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

The resulting table will look like this

Column A Column B

Cameron 7:00 AM
Cameron 5:15 PM
George 8:56 AM
George 2:59 PM
James 7:00 AM
James 5:30 PM

I know it will be easy to you Excel Experts as for me.... it gives me
hell of head ache.

If a different layout would be OK, you could use a Pivot Table.
Label each column: for Example Names Times

Insert / Pivot Table

Drag Names to Row Labels
Drag Times to Values
Change Value Field Settings to Min
Adjust format to Time
Drag Times to Values
Change Value Field Settings to Max
Adjust format to Time

Format and relabel areas to Taste

Results could be:

Times
Name Min Max
Cameron 5:15 AM 7:00 AM
George 2:59 AM 11:00 AM
James 5:30 AM 8:55 AM