Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Ref question | Excel Discussion (Misc queries) | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
Cell question | Excel Worksheet Functions | |||
Question in a function cell to cell | Excel Programming | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |