I was assuming they were all numbers <vbg

Good spot!

Bob

"Kris" wrote in message
...
Bob Phillips wrote:
Sort A1:A7 so that the empties are at the bottom and use

=OFFSET($A$1,,,COUNT($A$1:$A$7),1)



Perfect, with one correction COUNTA

Thanks