eliminate rows no complete

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!

I have:

A B C
1 x x
2 x x x
3 x

and

A B C
1 x - x
2 x x x
3 - x -

I need eliminate row 1 and 3 because there are blank
cells, or with certain value or character (- in example).
Is it possible with Excel formulae?
Thanks in advance.
an
 
Just add this formula to column D
=COUNTIF(A1:C1,"x")=3

and copy down.

Then Autofilter on the False value, and delete the visible rows.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks,
but all rows=FALSE (?)
an
-----Original Message-----
Just add this formula to column D
=COUNTIF(A1:C1,"x")=3

and copy down.

Then Autofilter on the False value, and delete the visible rows.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Yes, because the formula will return a False if there are not 3 x's in that
row.

Try it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Grateful for your help.

Certainly, there are a mistake on my guilt.
But I don't know where (?)

Sorry for all...
an
 
To both, Peo and Bob,

Excuse me, please.

I Closed my excel file and reopen it.
The exactly equal formulae, works fine.
I don't know why. (???)

Many thanks
an
 
Back
Top