How about something like...
=MAX(SUMPRODUCT(--($B$2:$B$65000=B2),--($A$2:$A$65000A2-1),--($A$2:$A$65000<A2+1),--($E$2:$E$65000)))
???
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Mr. Damon" wrote:

HELP!!! I'm doing a formula and I'm trying to get it to look at the last row
in column B every time I paste information in the worksheet I have included
my formula. All I see is the VB But I need it in formula. I need instead of
going to 4005 I need it to go to the end of the last row.

=MAX(SUMPRODUCT(($B$2:$B$4005=B2)*($A$2:$A$4005A2-1)*($A$2:$A$4005<A2+1)*($E$2:$E$4005)))

Thanks