Peo,
Thanks a lot. I guess I will have to use your suggestion, if I don't get
anything better. The problem is that I can't delete rows and it's a part of
larger workbook intended for an end user. They are not going to do all those
filter operations.

I should have mentioned this before, but I just thought about it.

The non-zero cells are populated based on another column with dates (column
J) via formula =(MONTH(J3)<MONTH(J4))*(Y3)

I am trying to calculate monthly return and column Y has daily asset value.
The problem is that some days are holidays or don't have any activity so
monthly periods are not constant.

Does this help?
Thanks again,
Greg

"Peo Sjoblom" wrote:

You could use dataautofilter, select 0 from dropdown, select and press F5,
click special and visible cell only, then delete the 0s. If you need to keep
them, from dropdown autofilter select custom, select rows that are not equal
to 0, then repeat and select visible cells only, copy and paste them
somewhere else and there you would have a list of numbers without the 0s.
Then just do something like

=H2&":"&H3

and copy down, if there are only 2 numbers you can use this formula

=A2&":"&INDEX(A3:A20,MATCH(TRUE,A3:A20<0,0))

entered with ctrl + shift & enter



Regards,

Peo Sjoblom

"Greg" wrote:

Hi,
I have a column with single numerical cells and zeros in between. See
example below.
All I need to take the ratio of the top number to next number in an adjacent
column. The problem is that rows with zeros between numbers vary, but # zero
rows is always greater than 5 and less than 30. I would like a formula
solution if possible.

Thanks a bunch.

1151
0
0
0
0
0
0
6262
0
0
0
0
0
0
0

--
______
Regards,
Greg