Assuming your data starts in F1, put this in G2 (notice that is G2, not G1)
and copy it down...

=IF(COUNTA(A1:A3)=1,TRUE,"")

--
Rick (MVP - Excel)


"jenn" wrote in message
...
this seems to apply true to all the blank lines... I need a 'true' if the
line above and the line below are blank.

"Mike H" wrote:

Hi,

Put this in g1 and drag down and sort on tcolumn G and delete all rows
that
evaluate as TRUE

=F1=""

Mike

"jenn" wrote:

I'm trying to figure out if there is a way to remove the non duplicate
items
from my list.

I have a rather large list that is separated by blank lines. Sometimes
there
is a blank line, a line of data and another blank line. Other times
there is
a blank line, 2 or more lines of data, then a blank line.

Can I write a formula in G5 that says if F4 and F6 are blank give me
"*"..
then filter for the stars and delete those lines?