find last cell in a column but not a formula
 

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

OK....that's more information, but I'm still puzzled about what you're
ultimately trying to find ,what you want to do once you find it, and what
obstacles you're facing.

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

I have a worksheet with a list of equipment and uptime rates. each week I
add a new row with the current weeks rate information. I use this data in a
powerpoint slide. So i used the formula in a different cell to pull just the
current weeks info. then I use that to link to the power point slides so it
auto updates. When I use the formula on a percentage it results in '1'
instead of percentage. thanks for everything in advance

"Ron Coderre" wrote:

OK....that's more information, but I'm still puzzled about what you're
ultimately trying to find ,what you want to do once you find it, and what
obstacles you're facing.

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

I have a worksheet with a list of equipment and uptime rates. each week I
add a new row with the current weeks rate information. I use this data in a
powerpoint slide. So i used the formula in a different cell to pull just the
current weeks info. then I use that to link to the power point slides so it
auto updates. When I use the formula on a percentage it results in '1'
instead of percentage. thanks for everything in advance

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

find last cell in a column but not a formula
 

Any chance that the problem is just a number formatting issue?

If you change the number format of the cell
containing your formula to Percentage does that fix it?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I have a worksheet with a list of equipment and uptime rates. each week I
add a new row with the current weeks rate information. I use this data in a
powerpoint slide. So i used the formula in a different cell to pull just the
current weeks info. then I use that to link to the power point slides so it
auto updates. When I use the formula on a percentage it results in '1'
instead of percentage. thanks for everything in advance

"Ron Coderre" wrote:

OK....that's more information, but I'm still puzzled about what you're
ultimately trying to find ,what you want to do once you find it, and what
obstacles you're facing.

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

Thanks, I cant believe I missed that.

"Ron Coderre" wrote:

Any chance that the problem is just a number formatting issue?

If you change the number format of the cell
containing your formula to Percentage does that fix it?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I have a worksheet with a list of equipment and uptime rates. each week I
add a new row with the current weeks rate information. I use this data in a
powerpoint slide. So i used the formula in a different cell to pull just the
current weeks info. then I use that to link to the power point slides so it
auto updates. When I use the formula on a percentage it results in '1'
instead of percentage. thanks for everything in advance

"Ron Coderre" wrote:

OK....that's more information, but I'm still puzzled about what you're
ultimately trying to find ,what you want to do once you find it, and what
obstacles you're facing.

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.

find last cell in a column but not a formula
 

Thanks for the feedback......If it wasn't a format problem, then I was out of
ideas.


***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

Thanks, I cant believe I missed that.

"Ron Coderre" wrote:

Any chance that the problem is just a number formatting issue?

If you change the number format of the cell
containing your formula to Percentage does that fix it?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I have a worksheet with a list of equipment and uptime rates. each week I
add a new row with the current weeks rate information. I use this data in a
powerpoint slide. So i used the formula in a different cell to pull just the
current weeks info. then I use that to link to the power point slides so it
auto updates. When I use the formula on a percentage it results in '1'
instead of percentage. thanks for everything in advance

"Ron Coderre" wrote:

OK....that's more information, but I'm still puzzled about what you're
ultimately trying to find ,what you want to do once you find it, and what
obstacles you're facing.

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I'm using the following formula to get the last cell:
=IF(COUNTA(A3:A97)=0,"None!",LOOKUP(2,1/(LEN(A3:A97)0),A3:A97))

the formulas in the cell is a simple percentage formula:
=(B13-C13-D13-E13)/B13

"Ron Coderre" wrote:

I think you'll need to post a few more details....

Like:
what formula(s) are you using?
What steps are you doing?

***********
Regards,
Ron

XL2002, WinXP


"WesT" wrote:

I want to select the last cell in a coloumn and paste the value but the cell
contents is a forumula and everyhting I have tried results in the 1 or error
instead of the result of the formula.