View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default St. Advanced Filter?

You can use a column to the right of the data (Column AE???) and fill it with
formulas like:

=counta(a2:ad2) (headers in row 1???)
and drag down.

Then you could filter or even sort by that column.




Maximus wrote:

I have about 2000 rows and 30 columns, each row does not always contain data
in the same column. My neck will be safe if I can identify the maximum amount
of rows sharing the same columns with data. So I could say, for example, that
184 rows had -at least- data in column 5, 8, 13, 16, 17 and 25. It is
possible that several rows in the selection have data in more columns.
I really would be grateful for any help.


--

Dave Peterson