Thanks:  0
Likes:  0

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

1. 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 ]

2. 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,

3. 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)

4. 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.

[ This Message was edited by: Aladin Akyurek on 2002-03-11 14:04 ]

5. 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.

6. 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!!!)

7. > 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•