| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
conditional display of certain rows
I would like to set up a workbook with two worksheets:
- Sheet1 will have numerous rows of data - Sheet2 will display only those rows from Sheet1 that meet a specified condition, e.g. Column H in Sheet1='yes' I'd like to accomplish this without displaying a bunch of blank rows that don't meet the desired condition. Is there a formula or a way to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not display rows where grand total is 0 | Excel Discussion (Misc queries) | |||
| Why does AutoFilter display rows NOT selected from drop down box? | Excel Discussion (Misc queries) | |||
| Display count of rows | Excel Worksheet Functions | |||
| Count Rows with Conditional Format? | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Threaded Mode
