View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Criteria for Advanced Filter HELP

Maybe simpler just to use autofilter on a helper col

Assume your 20 cols in cols A to T, data from row2 down
In say, U2: =COUNTA(A2:T2)=5
Copy U2 down. Then apply autofilter on col U, choose: TRUE

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---