Return non-zero cells in column
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
|