Hi John,

Am Sun, 13 Jan 2013 11:32:15 +0100 schrieb John:

1. =INDIRECT("A1:K"&COUNTIF(UK!A:A,"0"))
2. =OFFSET(UK!$A$1,0,0,Countif(UK!$A:$A,"<"&0),11)

try:
=OFFSET(UK!$A$1,,,COUNTA(UK!$A:$A),11)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2