Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone tell me how to hide rows that have 0 values and text.
I am trying to hide rows in an Excel Spreadsheet that my boss wants me to do.
I have rows with text and numbers in them and I have rows with text and 0 values in them. I want to only hide those rows - found out how to hide the 0 values but not how to hide the whole row with out going through each of them one by one (very time consuming). Thanks for any suggestions. Tracey |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone tell me how to hide rows that have 0 values and text.
Hi Tracey,
you might want to consider: xls database (rows = records, columns = fields), you add 1 more column, as a filter, named e.g. 'zero_row?': type in the cells =if(A1=0;0;1) , copy this function to all rows' cell (or autofill to the database), then in a) the autofilter or b) PivotTable you can filter to 1 value, to show only those rows where the value is < 0. i hope this helps, (at least, i use it this way :-) ), have fun, ANrdas (Hungary) "Aussie" wrote: I am trying to hide rows in an Excel Spreadsheet that my boss wants me to do. I have rows with text and numbers in them and I have rows with text and 0 values in them. I want to only hide those rows - found out how to hide the 0 values but not how to hide the whole row with out going through each of them one by one (very time consuming). Thanks for any suggestions. Tracey |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone tell me how to hide rows that have 0 values and text.
"Aussie" wrote in message
... I am trying to hide rows in an Excel Spreadsheet that my boss wants me to do. I have rows with text and numbers in them and I have rows with text and 0 values in them. I want to only hide those rows - found out how to hide the 0 values but not how to hide the whole row with out going through each of them one by one (very time consuming). Have you tried Data/ Filter/ Autofilter? Select column with zero and non-zero numbers. Custom/ does not equal/ 0 -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
text has numerical values | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |