Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for named cell/range based on cell values
hello,
perhaps somebody knows how to do this: in column A i have different values, for example: A B 1 aa 2 bb 3 cc in column B i want to define cells as reference to some named cells located elsewhere. for example: cell B1: =aatotal and so on in other cells: bbtotal, cctotal... how can i define formulas in B column based on values in A in order not to retype aa bb cc in all the cells. something like B1: =A1total ... ? thanks, Alex. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for named cell/range based on cell values
in B1
=Indirect(A1 & "total") then drag fill down the column -- Regards, Tom Ogilvy "alex" wrote in message ... hello, perhaps somebody knows how to do this: in column A i have different values, for example: A B 1 aa 2 bb 3 cc in column B i want to define cells as reference to some named cells located elsewhere. for example: cell B1: =aatotal and so on in other cells: bbtotal, cctotal... how can i define formulas in B column based on values in A in order not to retype aa bb cc in all the cells. something like B1: =A1total ... ? thanks, Alex. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for named cell/range based on cell values
thanks a lot
"Tom Ogilvy" wrote: in B1 =Indirect(A1 & "total") then drag fill down the column -- Regards, Tom Ogilvy "alex" wrote in message ... hello, perhaps somebody knows how to do this: in column A i have different values, for example: A B 1 aa 2 bb 3 cc in column B i want to define cells as reference to some named cells located elsewhere. for example: cell B1: =aatotal and so on in other cells: bbtotal, cctotal... how can i define formulas in B column based on values in A in order not to retype aa bb cc in all the cells. something like B1: =A1total ... ? thanks, Alex. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Based on Values in Named Range Q | Excel Worksheet Functions | |||
Q: Named range based on cell value? | Excel Discussion (Misc queries) | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
formula for named cell/range using cell values | Excel Worksheet Functions |