skipping rows with zero values

[Guest]

Hi there
Here's my problem - Want to be able to skip rows with zero values and place next non-zero row in the one skipped.
exampl
B1 1
B2
B3 1
Results wante
B1 1
B2 1
many thanks jojo

 

[mzehr]

Hi Jojo
Try using Autofilter, filter column B for 0 values, and
then delete those rows.

HTH

-----Original Message-----
Hi there,
Here's my problem - Want to be able to skip rows with

zero values and place next non-zero row in the one
skipped.

 

[mzehr]

Hi,
I would probably still use a filter, although I would use
an advanced filter. Insert a three rows in B1. Label
column B1 and B3 "Values", in B2 insert <>0.
Then Highlite B3:B8, run Data-Filter-Advanced Filter,
Check the Copy to another Location, In the criteria range
put B1:B2, Copy to C3

HTH

-----Original Message-----
Sorry I didn't explain myself well enough, the zeros

result from calculations. Look at this scenario

B1 14 C1 14
B2 0 C2 10
B3 10 C3 20
B4 0
B5 20 etc.. In essence I need a formula that I'll place

in C1 and copy down to pick up the non zero values only.
Hope I'm clear enough.

 

[Guest]

Worked to perfection

A hero, that's what you're
jojo