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