Looking Up the First Nonzero Value in a Column

Giganews Newsgroups
Subject: Looking Up the First Nonzero Value in a Column
Posted by:  TKrepitch (TKrepit…@aol.com)
Date: 23 Oct 2003

Hello everyone,

I am looking for a function that can return the first nonzero value in
a column.  I have a table that has months across the top and down the
leftmost column.  The data in the table are balances as of each month,
essentially.

It looks like this:

  J  F  M  A  M
J  1
F  2  1
M  3  2  1
A  4  3  2  1
M  5  4  3  2  1

Is there a way to say, "Look in the column labeled "F" and return the
first nonzero number"?  Then the cell below it will need to be the
number directly below that first number, and so on.  I'd appreciate
any help.  Thanks!

Sincerely,
Tom

Replies