Function needed

F

FMST

Hi everyone!
I need your help. I have a worksheet with many rows and 6 columns. Every
column has one number. I need to delete every row that has 3 or more numbers
followed.
E.g.
Col A Col B Col C Col D Col E Col F
1 5 20 21 22 70

Thank you very much
 
B

Barb Reinhardt

In the first empty column, I'd put

=count(A1:E1) (or whatever column you are counting to.

Then use the autofilter function to select the rows you want to delete.
 
D

driller

on column G
start data on Row2
H2 =if(count(A2:F2)>2,"delete this row","do not delete this row")
auto filter>delete this row
all visible/selected rows will be deleted which contain numbers from 3 to 6.
 
D

driller

FMST,
1. Make sure you have the original file stored separately.
2. Note: a number on a text format like "-1" or "+1" will not be read as a
number.
3. Make sure that you check the format of your the data - as you need it
like general or text.
 
Top