| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Picking up part of a formula from another cell
Can someone help please - I know Excel can do this because I have done
it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up part of a formula from another cell
Have a look at the INDIRECT function in Excel Help - this will allow
you to do what you are trying to do. Hope this helps. Pete On Oct 2, 9:16 am, david wrote: Can someone help please - I know Excel can do this because I have done it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up part of a formula from another cell
=COUNTIF(INDIRECT(M1&":"&N1),1)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "david" wrote in message oups.com... Can someone help please - I know Excel can do this because I have done it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up part of a formula from another cell
Sorry - I am being particulary thick!!
In the formula below I want the start letter of the range to come from A9 and the end letter from b9. The count will run between the intervening columns for row 13 only. Could I please be a pain and ask for the full format. Thanks David On 2 Oct, 09:46, "Bob Phillips" wrote: =COUNTIF(INDIRECT(M1&":"&N1),1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "david" wrote in message oups.com... Can someone help please - I know Excel can do this because I have done it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up part of a formula from another cell
Try this then:
=COUNTIF(INDIRECT(A9&"13:"&B9&"13"),1) Hope this helps. Pete On Oct 2, 4:12 pm, david wrote: Sorry - I am being particulary thick!! In the formula below I want the start letter of the range to come from A9 and the end letter from b9. The count will run between the intervening columns for row 13 only. Could I please be a pain and ask for the full format. Thanks David On 2 Oct, 09:46, "Bob Phillips" wrote: =COUNTIF(INDIRECT(M1&":"&N1),1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "david" wrote in message roups.com... Can someone help please - I know Excel can do this because I have done it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up part of a formula from another cell
The INDIRECT function takes a text string as its input, so you need to
generate the appropriate text string for your range. If you are trying to produce the formula =COUNTIF(D13:Z13,1) by putting the D in A9, and the Z in B9, try the formula: =COUNTIF(INDIRECT(A9&"13:"&B9&"13"),1) -- David Biddulph "david" wrote in message ups.com... Sorry - I am being particulary thick!! In the formula below I want the start letter of the range to come from A9 and the end letter from b9. The count will run between the intervening columns for row 13 only. Could I please be a pain and ask for the full format. Thanks David On 2 Oct, 09:46, "Bob Phillips" wrote: =COUNTIF(INDIRECT(M1&":"&N1),1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "david" wrote in message oups.com... Can someone help please - I know Excel can do this because I have done it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up part of a formula from another cell
Thanks to all
David On 2 Oct, 17:01, "David Biddulph" <groups [at] biddulph.org.uk wrote: The INDIRECT function takes a text string as its input, so you need to generate the appropriate text string for your range. If you are trying to produce the formula =COUNTIF(D13:Z13,1) by putting the D in A9, and the Z in B9, try the formula: =COUNTIF(INDIRECT(A9&"13:"&B9&"13"),1) -- David Biddulph "david" wrote in message ups.com... Sorry - I am being particulary thick!! In the formula below I want the start letter of the range to come from A9 and the end letter from b9. The count will run between the intervening columns for row 13 only. Could I please be a pain and ask for the full format. Thanks David On 2 Oct, 09:46, "Bob Phillips" wrote: =COUNTIF(INDIRECT(M1&":"&N1),1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "david" wrote in message groups.com... Can someone help please - I know Excel can do this because I have done it before but have forgotten how (I blame my age!!) I want to have a formula in a cell that picks up the letter part of the cell reference from another cell. ie I want to do a countif a cell range equals 1 where the column letter of the start of the cell range and the end of the cell range come from two separate cells. This is so I can modify just those two cells and automatically update all the formulae in the worksheet. I am working with both Excel 2000 & 2003 Thanks David- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formula not picking up 1st of the month (weekday) | Excel Discussion (Misc queries) | |||
| how to put 'SUM' formula in VB after picking up certain names and their bonus | Excel Discussion (Misc queries) | |||
| Picking figures out of a cell | Excel Discussion (Misc queries) | |||
| Can I use cell contents as part of a formula? | Excel Worksheet Functions | |||
| Picking up the last non-empty cell in a given range | Excel Discussion (Misc queries) | |||
Linear Mode
