Filtered Columns!
 

Hi

I need something either simple or impossible :)

I'd put filter on a row, in my case it's 3rd row.

There is near 100 columns with data, and in that row are numbers 5, 10, 15
and 60 and empty cells. So I want to separate columns, as it's obvious,
like filter does for rows.

Is there some way to do this?


Boris

Filtered Columns!
 

Hi Boris,

There is no built in command to filter horizontally, but you can do the same
thing. But it depends on what you want to do with it.

Do you want to hide all the columns for which there is no data on a given
row? Or do you want to display only columns for which the given row has an
amount greater than x?

Cheers,
Shane

"Boris" wrote in message news:op.ucedlrmcwhv0ff@dx...
Hi

I need something either simple or impossible :)

I'd put filter on a row, in my case it's 3rd row.

There is near 100 columns with data, and in that row are numbers 5, 10, 15
and 60 and empty cells. So I want to separate columns, as it's obvious,
like filter does for rows.

Is there some way to do this?


Boris