Hey Biff,

That's exactly the type of thing I was looking for ... but ;) when I
use the formula all I get are the largest dates in all cells (as I fill
over I just keep getting more and more columns of the largest date).

I'll try to disect it now and figure out what's going on ... but let me
know if you see an error. I used the following specifically (array
entered):

=IF(ISERROR(LARGE(IF(Import!$A$1:$A$1346=$A1,Impor t!$B$1:$B$1346),COUNTIF(Import!$A$1:$A$1346,$A1)-(COLUMN(A:A)-1))),"",LARGE(IF(Import!$A$1:$A$1346=$A1,Import!$B $1:$B$1346),COUNTIF(Import!$A$1:$A$1346,$A1)-(COLUMN(A:A)-1)))

Either way, thanks so much!


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=382077