Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to analyse data across a number of filtered columns | New Users to Excel | |||
How to hide columns that are not filtered? | Excel Worksheet Functions | |||
Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns | Excel Worksheet Functions | |||
Filtered list & maximum no columns problem | Excel Discussion (Misc queries) | |||
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns | Excel Worksheet Functions |