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
|