Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show the Last entry
I built a basic spreadsheet (Excel 2002) the is used for check book
balancing. There will be over 100+ rows and I would like the current balance to always show above the "freeze" line(row 5) in cell J4. Is there a formula to display this? TIA Bg |
#2
|
|||
|
|||
This will give you the last *numeric* entry in Column A:
=LOOKUP(9.99999999999999E+307,A:A) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bg" wrote in message ... I built a basic spreadsheet (Excel 2002) the is used for check book balancing. There will be over 100+ rows and I would like the current balance to always show above the "freeze" line(row 5) in cell J4. Is there a formula to display this? TIA Bg |
#3
|
|||
|
|||
If your current balance is in column J, array-enter the following formula
into cell J4 (use <Ctrl <Shift <Enter rather than just <Enter): =INDEX(J5:J65536,MAX((J5:J65536<"")*ROW(J5:J65536 ))-4) I'm sure there's a much more elegant way but this should do the job. -- Vasant "Bg" wrote in message ... I built a basic spreadsheet (Excel 2002) the is used for check book balancing. There will be over 100+ rows and I would like the current balance to always show above the "freeze" line(row 5) in cell J4. Is there a formula to display this? TIA Bg |
#4
|
|||
|
|||
Thanks to all for your help. That works
Bg "Bg" wrote in message ... I built a basic spreadsheet (Excel 2002) the is used for check book balancing. There will be over 100+ rows and I would like the current balance to always show above the "freeze" line(row 5) in cell J4. Is there a formula to display this? TIA Bg |
#5
|
|||
|
|||
Unless you are going to enter the equation to subtract (add) the output from
(input to) the account in each line. I would just copy the Balance equation down to some high row number. Set row 5 value to equal the bottom cell. and if you don't want to see the non-input/output balance I would use conditional formating to make the text be invisible [ equation "= not(or(asset<0,debit<0))" format ";;;"] I would then protect this column so that I wouldn't acidentally enter something over it. Concidering how I type, It would be fairly often. "Bg" wrote: Thanks to all for your help. That works Bg "Bg" wrote in message ... I built a basic spreadsheet (Excel 2002) the is used for check book balancing. There will be over 100+ rows and I would like the current balance to always show above the "freeze" line(row 5) in cell J4. Is there a formula to display this? TIA Bg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Finding last entry in column | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |