On Dec 31 2009, 11:35*am, OssieMac
wrote:
Afterthought. Try using
=OFFSET(Sheet1!$A$1,0,0,COUNTA($A:$A)-COUNTIF($A:$A,"=x"))

That should return the result you want.

--
Regards,

OssieMac

You are right, the WB was created for Excel 2003 hence the lower
number.
Blanks are not equal -x I missed that ...Thank you for pointing me to
the right direction.
As for your last Iteration....Worked like a charm....Have a lovely New
year.