If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Min, Max
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Min, Max

#1
July 14th 12, 10:29 AM
 jonz erazol Junior Member First recorded activity by ExcelBanter: Jul 2012 Posts: 1
Min, Max

Good day...
Im just new in using ms excel 2007.

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.
#2
July 14th 12, 02:54 PM posted to microsoft.public.excel.newusers
 Claus Busch external usenet poster Posts: 943
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
#3
July 14th 12, 02:58 PM posted to microsoft.public.excel.newusers
 Claus Busch external usenet poster Posts: 943
Min, Max

Hi Jonz,

Am Sat, 14 Jul 2012 15:54:54 +0200 schrieb Claus Busch:

> try:
> =MIN(WENN(A1:A100="Cameron";B1:B100))
> and
> =MAX(WENN(A1:A100="Cameron";B1:B100))
> enter both formulas with CTRL+Shift+Enter

sorry that I posted the formulas in German. Here now in English:
=MIN(IF(A1:A100="James",B1:B100))
and
=MAX(IF(A1:A100="James",B1:B100))

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
#4
July 14th 12, 03:41 PM posted to microsoft.public.excel.newusers
 Ron Rosenfeld[_2_] external usenet poster Posts: 894
Min, Max

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

>
>Good day...
>Im just new in using ms excel 2007.
>
>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

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
Drag Times to Values
Change Value Field Settings to Max

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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

All times are GMT +1. The time now is 12:56 AM.