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