Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find first previous cell with data
Hi, I am not "fluent" in Excel, so please make any answers "dummy" level.
I have a running balance column that spans multiple pages and I am trying to get the last balance from the previous page onto a cell in the following page. Additionally, there are column headings at the beginning of each page and I have all cells (except column heading cells) in this balance column conditionally formatted to not display duplicate balances, so there are cells that appear blank but technically are not. I read a post in General Questions dated 1/16/2006 by Derby Jim and answered by Bob Phillips that sounded like my situation. I tried both solutions that Bob presented and neither worked. I set up test worksheet as exampled in the post, used both formulas and both returned 0. Any help would be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to find the data of a next cell in a list | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
how to find last cell in column with data | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |