St. Advanced Filter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Hi,

Refer to "Filter by using advanced criteria" in the Microdoft on-line help

Challa Prabhu
 
Hi,

Refer to "Filter by using advanced criteria" in the Microdoft on-line help

Challa Prabhu
 
Back
Top