| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide rows where cell condition is not met
How can hide rows where a cell condition is not met? ie, If two cells (same
row) are not equal, hide the row. Otherwise I have put a formula that compares the two cells and returns TRUE or FALSE. I want to hide the TRUEs not delete and I don't want to sort the sheet based on this result. I just want to hide/display. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hide rows where cell condition is not met
Use AutoFilter and hide the rows based on the condition in your helper
column Regards Trevor "amaries" wrote in message ... How can hide rows where a cell condition is not met? ie, If two cells (same row) are not equal, hide the row. Otherwise I have put a formula that compares the two cells and returns TRUE or FALSE. I want to hide the TRUEs not delete and I don't want to sort the sheet based on this result. I just want to hide/display. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
| Rows to drop off (hide) when a value is entered into a cell | Excel Discussion (Misc queries) | |||
| Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Linear Mode
