Hi Boris,
Did you try filtering the list see Debra Dalgleish's index page
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"BorisS" wrote in message ...
I am getting lots of values in my table which are zero. I have a calculated
item, and don't know if that is the problem. How, if at all, can I get any
line which has all zeros to not show up? the table gets excessively long
with them, not to mention the calculation takes forever.

--
Boris