[SOLVED] Help with Excel and links

mackey · 09-19-2007, 07:47 AM

Using Office 2003. I have a financial spreadsheet where data is entered across columns with the latest monetary value manually entered. Example:

B2 5423
B3 7324
B4 6532 (All dollar amounts)

Then at the bottom of the column(s) the latest value is manually rentered and then totalled across the columns.

B22 6532 (same as most recent entry above)

My question is: How can I have the data entered in B4 (in this example) also be automatically entered in B22? In other words, how can I avoid having to duplicate the most recent or current money value entries at the bottom of the chart?

Bill

**gistek** · 09-19-2007, 10:24 AM

If you have record numbers in column A you can use

=LOOKUP(MAX(A1:A19),A1:B19)

For the table
A B
1 5423
2 7324
3 6532

B22 will have 6532

When you add a 4th number
A B
1 5423
2 7324
3 6532
4 1254

B22 will change to 1254

mackey · 09-19-2007, 05:43 PM

Solved with the great help of Gistek!

09-19-2007, 07:47 AM	#1 (permalink)
mackey Registered User Join Date: Mar 2005 Posts: 77 OS: XP & Vista	[SOLVED] Help with Excel and links Using Office 2003. I have a financial spreadsheet where data is entered across columns with the latest monetary value manually entered. Example: B2 5423 B3 7324 B4 6532 (All dollar amounts) Then at the bottom of the column(s) the latest value is manually rentered and then totalled across the columns. B22 6532 (same as most recent entry above) My question is: How can I have the data entered in B4 (in this example) also be automatically entered in B22? In other words, how can I avoid having to duplicate the most recent or current money value entries at the bottom of the chart? Bill

09-19-2007, 10:24 AM	#2 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,914 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Help with Excel and links If you have record numbers in column A you can use =LOOKUP(MAX(A1:A19),A1:B19) For the table A B 1 5423 2 7324 3 6532 B22 will have 6532 When you add a 4th number A B 1 5423 2 7324 3 6532 4 1254 B22 will change to 1254 __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team

09-19-2007, 05:43 PM	#3 (permalink)
mackey Registered User Join Date: Mar 2005 Posts: 77 OS: XP & Vista	Re: Help with Excel and links Solved with the great help of Gistek!