Andy Pope shows how to do this via te use of dynamic range names here . . .
http://www.andypope.info/charts/piezeros.htm
----
Regards,
John Mansfield
http://www.pdbook.com
"DMc2005" wrote:
Hi
I currently have some data as shown below:
Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9
How can I exclude the zero items automatically, the data shown below is
going to change regulary and i do not want to have to keep change the source
data manually.
D