T
TKrepitch
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
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