St. Advanced Filter?
 

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.

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

St. Advanced Filter?
 

Hi,

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

Challa Prabhu


"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.

St. Advanced Filter?
 

Hi,

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

Challa Prabhu

"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.