View Single Post
  #1   Report Post  
Greg
 
Posts: n/a
Default 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