Using excel to track stock portfolio

[fm757]

Lets say I use column A to keep a daily run of my portfolio value. A1 would be Jul 1 value, A2 would be Jul 2 value and so on down the column. Now in cell D1 I want displayed the current days value(last cell value in column A). Is this possible to do with excel?

Thanks

 

[SIXTH SENSE]

Hi!
Try this.

=INDEX(A:A,COUNTA(A:A))

 

[fm757]

Sixth Sense,

Thank you very much for the quick response. That works very well.

 

[SIXTH SENSE]

Enjoy!

 

[fm757]

One thing I did notice with this formula is that it doesn't work if you have two cells merged. Is the formula different if you are working with merged cells?

 

[Yogi Anand]

Hi fm757:

I can use the following formula in cell D1 ...

=LOOKUP(9.99999999999999E+307,A:A)

and here is an illustration ...

Book1
	A	B	C	D
1	1-Jul			10-Jul
2	2-Jul
3	3-Jul
4	4-Jul
5	5-Jul
6
7	6-Jul
8	7-Jul
9	8-Jul
10	9-Jul
11
12	10-Jul
Sheet2

 

[fm757]

Yogi,

That works great. I don't understand the formula, but it works great!

Thanks

 

[Yogi Anand]

Hi fm757:

I am glad it works for you.

What the formula is doing is LOOKing up the last numeric entry in column A, using the largest number that can be entered in EXCEL.

 

[fm757]

Yogi,

What does the 9.999999999999E+304 mean in the formula?

Thanks,
fm757

 

[Yogi Anand]

Hi fm757:

9.99999999999999E+307 in Scientific notation (which stands for 9.99999999999999*10^307) is the largest number that can be entered in EXCEL.