| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
omit zeroes from a list
Say i have a list in a column
A B 0 0 C D 0 E I would like to have a list that is the same as above but omits the zeroes in another column, without hiding rows. A B C D E But not an autofilter bar, as I'd like for the list to automatically omit the zeroes without having to mess with an autofilter bar. Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set the default for "show zeroes" to not show the zeroes? | Setting up and Configuration of Excel | |||
| Data validation, select from list: omit blanks? | Excel Discussion (Misc queries) | |||
| how do i omit the a list, and it's matches, so neither exists? | Excel Worksheet Functions | |||
| How do I represent omit in a list of data in excell? | Excel Discussion (Misc queries) | |||
| Dropdown list in PivotTable has deleted items. How to omit? | Excel Discussion (Misc queries) | |||
Threaded Mode
