Thread: skipping zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default skipping zeros

hello i have the following data:

A B C
1 0 -1000 -1000
2 0 0 0
3 100 0 100
4 0 0 0
5 0 0 0
6 0 0 0
7 200 0 200
8 300 0 300

i would like to skip the zeros and make the following :

0 -1000 -1000
100 0 100
200 0 200
300 0 300

IS THERE ANY FORMULA FOR THAT ??