Find Max in date field by customer

Trying to keep it non-array entered.

=SUMPRODUCT(LARGE((CustRng=B2)*(DateRng),COUNTIF(CustRng,B2)
))


Regards
Robert McCurdy
"Come on Argentina!"

----- Original Message ----- 
From: "Shawn Bumgarner" <sbumgarn2002YAHOO.COM>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Friday, June 30, 2006 6:26 AM
Subject: Re: Find Max in date field by customer


> Question for anyone out there - I was trying to tweak
this formula to give me back the minimum date (substituting
MIN for MAX in the spot but it did not work, comes back as
zero (0).  Is there something I'm doing wrong?  Thanks.
>   
>  =SUMPRODUCT(MAX((CustRng=B2)*DateRng))
> 
>  becomes...
>   
>  =SUMPRODUCT(MIN((CustRng=B2)*DateRng))
>   
>  but did not work for me???
> 
> 
> Robert McCurdy <robertwmORCON.NET.NZ> wrote:
>  Yo Shawn, this one is an Array formula.
> 
> =MAX(IF(CustRng=B2,DateRng))
> 
> and this one is a normally entered formula (but still
an array 
> 
> =SUMPRODUCT(MAX((CustRng=B2)*DateRng))
> 
> Where B2 is the start of your customer range.
> 
> 
> Regards
> Robert McCurdy
> 
> ----- Original Message ----- 
> From: "Shawn Bumgarner" 
> To: 
> Sent: Tuesday, June 27, 2006 1:35 AM
> Subject: Find Max in date field by customer
> 
> 
>> Hi everyone, I have a contact log in an Excel 2000
worksheet that has two relevant fields for my question,
customer number and date of contact. In another sheet I have
a unique list of all those customers and I would like to
have a formula to show me the date of last contact for each
customer. I'm thinking it would be a form of the sumproduct
formula with a nested Max() formula inside of it? Anyone
with ideas please let me know, thank you.
>> 
>> Shawn
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software. For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> 
> 
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G