Stewart,

Many thanks for your help - very useful - didn't know there was such a
function!

Best wishes

Tony

"Datasort" wrote:

Try using the =ISBLANK() function and then sort the data by true/false

The isblank will tell you if a cell is blank. This would assume that the
valid rows of data have a value in at least one column. If you can't depend
of there always being a value in a specific column then you the
and(isblank(a1), isblankk(b1), ...) funtion to test multiple values.

Good Luck

--
Stewart Rogers
DataSort Software, L.C.