Cell question
 

I have a large spreadsheet with scattered amounts in cells; i.e., going
across from left to right, JAN, FEB, MAR, APR, etc.

Each customer has his own row and some customers have balances in the
different months, different from other customers; i.e., Joe Blow will have a
balance current up to March, and then nothing from March to July -- or to
December for that matter -- while Fred Smith will have a balance from
January and a balance every month for the whole year. If there is no
balance for the month, the cell is blank. I want to put the latest NONZERO
amount in a column to the right of December with the most current NONZERO
amount in that column. In other words, if the latest amount for Smith is in
April and then from May to the end of the year it's blank, I want April's
amount in the column. If the latest amount for Jones is in June, I want
that amount in the column.

My question is: What is the formula I need to use to search LEFT in a row
for the first nonzero amount, skipping blank cells??

Thanks in advance....

Cell question
 

hapster

Try this formula

=SUM((COLUMN(A3:L3)=MAX((COLUMN(A3:L3)*(A3:L30))) )*(A3:L3))

Enter with Control+Shift+Enter, not just Enter.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"hapster" wrote in message
...
I have a large spreadsheet with scattered amounts in cells; i.e., going
across from left to right, JAN, FEB, MAR, APR, etc.

Each customer has his own row and some customers have balances in the
different months, different from other customers; i.e., Joe Blow will have
a
balance current up to March, and then nothing from March to July -- or to
December for that matter -- while Fred Smith will have a balance from
January and a balance every month for the whole year. If there is no
balance for the month, the cell is blank. I want to put the latest
NONZERO
amount in a column to the right of December with the most current NONZERO
amount in that column. In other words, if the latest amount for Smith is
in
April and then from May to the end of the year it's blank, I want April's
amount in the column. If the latest amount for Jones is in June, I want
that amount in the column.

My question is: What is the formula I need to use to search LEFT in a row
for the first nonzero amount, skipping blank cells??

Thanks in advance....