Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to appy range names to formulas which use single cells in rang
Hello!
How to appy a thousand new range names to formulas which use corresponding single cells in the ranges? Regards, Dmitry |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to appy range names to formulas which use single cells in rang
Dmitry -
Several of your questions have been short, general, and vague to the point of not posing a question that can be answered. Please provide better detail and explanation of what you are trying to do. "Dima" wrote: Hello! How to appy a thousand new range names to formulas which use corresponding single cells in the ranges? Regards, Dmitry |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to appy range names to formulas which use single cells in
Hello!
How to replace thousands of single cell references (for example, A1) with row names? The formulas and its precidents are in a same column. For example: row name: rowName = $1:$1 The formula in D1000 =D1 How to replace =D1 with =rowName in cell D1000 automatically? There are thousands cells like D1000 and row names like the rowName. Regards, Dmitry "Duke Carey" wrote: Dmitry - Several of your questions have been short, general, and vague to the point of not posing a question that can be answered. Please provide better detail and explanation of what you are trying to do. "Dima" wrote: Hello! How to appy a thousand new range names to formulas which use corresponding single cells in the ranges? Regards, Dmitry |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to appy range names to formulas which use single cells in
Insert-Name-Apply
That may require you to go through each range name, one at a time, though. If so, you could "Dima" wrote: Hello! How to replace thousands of single cell references (for example, A1) with row names? The formulas and its precidents are in a same column. For example: row name: rowName = $1:$1 The formula in D1000 =D1 How to replace =D1 with =rowName in cell D1000 automatically? There are thousands cells like D1000 and row names like the rowName. Regards, Dmitry "Duke Carey" wrote: Dmitry - Several of your questions have been short, general, and vague to the point of not posing a question that can be answered. Please provide better detail and explanation of what you are trying to do. "Dima" wrote: Hello! How to appy a thousand new range names to formulas which use corresponding single cells in the ranges? Regards, Dmitry |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to appy range names to formulas which use single cells in
Thanks Duke Carey for replying!
Insert-Name-Apply would apply the row names (rowName) to the rows (first row) only. Insert-Name-Apply does not apply the row names (rowName) instead of the single cell references like D1000 =D1 in my example. There is about a thousand such names on the sheet. Please, help! Regards, Dmitry "Duke Carey" wrote: Insert-Name-Apply That may require you to go through each range name, one at a time, though. If so, you could "Dima" wrote: Hello! How to replace thousands of single cell references (for example, A1) with row names? The formulas and its precidents are in a same column. For example: row name: rowName = $1:$1 The formula in D1000 =D1 How to replace =D1 with =rowName in cell D1000 automatically? There are thousands cells like D1000 and row names like the rowName. Regards, Dmitry "Duke Carey" wrote: Dmitry - Several of your questions have been short, general, and vague to the point of not posing a question that can be answered. Please provide better detail and explanation of what you are trying to do. "Dima" wrote: Hello! How to appy a thousand new range names to formulas which use corresponding single cells in the ranges? Regards, Dmitry |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to appy range names to formulas which use single cells in
Thanks Duke Carey for replying!
Insert-Name-Apply would apply the row names (rowName, in my example) to the rows (first row, in my example) only. Insert-Name-Apply does not apply the row names (rowName, in my example) instead of the single cell references (=D1 in D1000 cell in my example). There is about a thousand such names on the sheet. How to replace the single cell references with the row names? Regards, Dmitry "Duke Carey" wrote: Insert-Name-Apply That may require you to go through each range name, one at a time, though. If so, you could "Dima" wrote: Hello! How to replace thousands of single cell references (for example, A1) with row names? The formulas and its precidents are in a same column. For example: row name: rowName = $1:$1 The formula in D1000 =D1 How to replace =D1 with =rowName in cell D1000 automatically? There are thousands cells like D1000 and row names like the rowName. Regards, Dmitry "Duke Carey" wrote: Dmitry - Several of your questions have been short, general, and vague to the point of not posing a question that can be answered. Please provide better detail and explanation of what you are trying to do. "Dima" wrote: Hello! How to appy a thousand new range names to formulas which use corresponding single cells in the ranges? Regards, Dmitry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
How to appy range names to formulas which use single cells in rang | Excel Discussion (Misc queries) | |||
How to appy range names to formulas which use single cells in rang | Excel Worksheet Functions | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
How do i separate full names appearing in single cells? | Excel Worksheet Functions |