I need to always select the last populated cell of a column.

[megslow]

ok, now that i'm registered, i'll try the question again...

My question:

I need to have a cell at the top of my sheet always show me what the value is in the last populated cell of one particular column. The value of the cell is numeric... actually a formula accruing vacation and sick time for employees of my company.

Can this be done with a formula? I have tried everything I can think of and looked everywhere I know. Please help!

Thanks,
Meg.
This message was edited by megslow on 2002-03-11 14:01

 

[Aladin Akyurek]

On 2002-03-11 13:54, megslow wrote:
ok, now that i'm registered, i'll try the question again...

My question:

I need to have a cell at the top of my sheet always show me what the value is in the last populated cell of one particular column. The value of the cell is numeric... actually a formula accruing vacation and sick time for employees of my company.

Can this be done with a formula? I have tried everything I can think of and looked everywhere I know. Please help!

Thanks,
Meg.

Meg,

See my reply to your anonymous post.

Aladin

 

[megslow]

If the column in question is "F", do I replace the "B" in the following formula with "F"?
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
(if so, i tried and it didn't work)

 

[Aladin Akyurek]

On 2002-03-11 14:01, megslow wrote:
If the column in question is "F", do I replace the "B" in the following formula with "F"?
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
(if so, i tried and it didn't work)

Yes, Meg. B:B becomes F:F. You need to enter the formula in F1.

Aladin
This message was edited by Aladin Akyurek on 2002-03-11 14:04

 

[megslow]

Ok, I tried the formula with the "F"s in cell F1 at home with sample data and it worked. However I cannot get it to work here at work where I need it. I am using Excel 2000 (home is XP). Will that make a difference? Also, there is some text in some of the cells in column F. Will that mess up the formula?

Thanks so much for your help so far...
Meg.

 

[megslow]

new issue: the formula works in some workbooks but not others... weird. but the point is that i DID get it to work.
thank you, thank you, thank you!

(and any tips on why it may not work in some workbooks - like settings? - would be appreciated!!!)

 

[Aladin Akyurek]

> Ok, I tried the formula with the "F"s in cell F1 at home with sample data and it worked.

> However I cannot get it to work here at work where I need it. I am using Excel 2000 (home is XP). Will that make a difference?

It works in Excel 2000. Glad to hear that it does work in XP.

> Also, there is some text in some of the cells in column F. Will that mess up the formula?

Match ignores text and blanks, so don't worry.

> Thanks so much for your help so far...

You're welcome.

Aladin