Thread: Function needed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Function needed

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.



"FMST" wrote:

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