Use a helper column with =COUNT(K1)+COUNT(M1)
This will give you values 0, 1 and 2; you could sort or use AutoFilter to
get what you need.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Golfinray" wrote in message
...
I have the following info on an Excell 2003 sheet:

column K column M
10/01/2006 10/21/2006
11/03/2006
11/28/2006
12/01/2006 12/22/2006
12/18/2006 4/8/2007

In other words, some cells have both dates, some only one, some neither. I
only want to return the ones where ONE cell in the row is blank or null.
Thanks so much!!!!