Thread: Min, Max
View Single Post
  #1   Report Post  
jonz erazol jonz erazol is offline
Junior Member
 
Posts: 1
Default Min, Max

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.