Row hieght formula

F

funktastic

I was wondering if there is a formula for row height. I have a lon
list, and I want each row that returns a 0 to collapse automatically.
Anyone know how to do that
 
K

Kevin M

You should hide them. I'm not too keen on Visual Basic, but that's where
you'd need to go to automate it. If you'd like to do it manually you can
filter the cells.

HTH,
Kevin M
 
D

David McRitchie

The filtering is the easiest. If you want your totals to change
you will have to use SUBTOTAL(9, ....)

For how to filter go to Debra Dalgleish's site
http://www.contextures.com
look for Excel tips or developer tips for the index.
 
Top