skipping rows with zero values

J

jojo

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
 
M

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
Click to expand...
zero values and place next non-zero row in the one
skipped.
 
M

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
Click to expand...
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
Click to expand...
in C1 and copy down to pick up the non zero values only.
Hope I'm clear enough.
 
Top