| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
