Formula question
 

Hi everyone and thanks in advance for any help. You guys always seem to have
the answer I need.

I am using XP Pro and Office Pro 2003.

I am in charge of the membership and dues payments for a small club. I have
an Excel notebook with a different page (tab) for each member. On each page I
have the members info (name, address, phone, etc.). Then starting on line 10
and continuing down the page, I have the following info entered:

Column A: Date
Column B: Activity (i.e. paid dues cash, or ck #xx, etc.)
Column C: Dues (membership) paid through

Every time the member pays their dues I enter the info on the next line
down, and then I manually enter in Column C the date their membership
expires. However, as time goes on the most current membership info is down so
far on the page I have to scroll down to see it.

I have a cell up in the heading part of the page that is for the current
membership expiration date (Cell D4). I need a formula for D4 that looks for
the bottom most entry in Column C and duplicates the date into cell D4. I
suppose I could do it with a huge string of IF questions, but there ought to
be an easier way.

Any ideas?

Thanks,
Jim

Formula question
 

=LOOKUP(99^99,C:C)
Enter in cell D4 and format as date.

"Jim Peterson" wrote:

Hi everyone and thanks in advance for any help. You guys always seem to have
the answer I need.

I am using XP Pro and Office Pro 2003.

I am in charge of the membership and dues payments for a small club. I have
an Excel notebook with a different page (tab) for each member. On each page I
have the members info (name, address, phone, etc.). Then starting on line 10
and continuing down the page, I have the following info entered:

Column A: Date
Column B: Activity (i.e. paid dues cash, or ck #xx, etc.)
Column C: Dues (membership) paid through

Every time the member pays their dues I enter the info on the next line
down, and then I manually enter in Column C the date their membership
expires. However, as time goes on the most current membership info is down so
far on the page I have to scroll down to see it.

I have a cell up in the heading part of the page that is for the current
membership expiration date (Cell D4). I need a formula for D4 that looks for
the bottom most entry in Column C and duplicates the date into cell D4. I
suppose I could do it with a huge string of IF questions, but there ought to
be an easier way.

Any ideas?

Thanks,
Jim

Formula question
 

Thanks Boni, that'll work!
Jim

"BoniM" wrote:

=LOOKUP(99^99,C:C)
Enter in cell D4 and format as date.

"Jim Peterson" wrote:

Hi everyone and thanks in advance for any help. You guys always seem to have
the answer I need.

I am using XP Pro and Office Pro 2003.

I am in charge of the membership and dues payments for a small club. I have
an Excel notebook with a different page (tab) for each member. On each page I
have the members info (name, address, phone, etc.). Then starting on line 10
and continuing down the page, I have the following info entered:

Column A: Date
Column B: Activity (i.e. paid dues cash, or ck #xx, etc.)
Column C: Dues (membership) paid through

Every time the member pays their dues I enter the info on the next line
down, and then I manually enter in Column C the date their membership
expires. However, as time goes on the most current membership info is down so
far on the page I have to scroll down to see it.

I have a cell up in the heading part of the page that is for the current
membership expiration date (Cell D4). I need a formula for D4 that looks for
the bottom most entry in Column C and duplicates the date into cell D4. I
suppose I could do it with a huge string of IF questions, but there ought to
be an easier way.

Any ideas?

Thanks,
Jim

Formula question
 

You are very welcome... happy to help!

"Jim Peterson" wrote:

Thanks Boni, that'll work!
Jim

"BoniM" wrote:

=LOOKUP(99^99,C:C)
Enter in cell D4 and format as date.

"Jim Peterson" wrote:

Hi everyone and thanks in advance for any help. You guys always seem to have
the answer I need.

I am using XP Pro and Office Pro 2003.

I am in charge of the membership and dues payments for a small club. I have
an Excel notebook with a different page (tab) for each member. On each page I
have the members info (name, address, phone, etc.). Then starting on line 10
and continuing down the page, I have the following info entered:

Column A: Date
Column B: Activity (i.e. paid dues cash, or ck #xx, etc.)
Column C: Dues (membership) paid through

Every time the member pays their dues I enter the info on the next line
down, and then I manually enter in Column C the date their membership
expires. However, as time goes on the most current membership info is down so
far on the page I have to scroll down to see it.

I have a cell up in the heading part of the page that is for the current
membership expiration date (Cell D4). I need a formula for D4 that looks for
the bottom most entry in Column C and duplicates the date into cell D4. I
suppose I could do it with a huge string of IF questions, but there ought to
be an easier way.

Any ideas?

Thanks,
Jim