Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parameterisation of table names
Hello
I need to name various tables in excel, by tables I mean a group of cells (e.g A1:D56). However I need to parameterise the name of the table to equal another cell. I know this may seem like a trivial matter but I really can't find how to do it anywhere, please help. Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parameterisation of table names
Use a defined name:
Insert Name Define So if A1 thru D10 have values and the Name blok has been assigned to this range then: =SUM(blok) will display the same as =SUM(A1:D10) and if H1 contains the text blok, then: =SUM(INDIRECT(H1)) will do the same. -- Gary''s Student - gsnu201001 "Tom O''Riordan" wrote: Hello I need to name various tables in excel, by tables I mean a group of cells (e.g A1:D56). However I need to parameterise the name of the table to equal another cell. I know this may seem like a trivial matter but I really can't find how to do it anywhere, please help. Tom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parameterisation of table names
Hi Tom
It sounds as though you need the Indirect function. If your named ranges are Group1, Group2 etc. and in cell D1 you had the value Group1, then to refer to that range it would be =INDIRECT(D1) Alternatively, if you just had a number 1 in cell D1 then =INDIRECT("Group"&D1) Regards Roger Govier Tom O''Riordan wrote: Hello I need to name various tables in excel, by tables I mean a group of cells (e.g A1:D56). However I need to parameterise the name of the table to equal another cell. I know this may seem like a trivial matter but I really can't find how to do it anywhere, please help. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Field Names | Excel Discussion (Misc queries) | |||
Delete Table Names | New Users to Excel | |||
Matching names to numbers in a table | Excel Worksheet Functions | |||
SIMILAR NAMES IN A TABLE | Excel Discussion (Misc queries) | |||
Pivot table field names | Excel Worksheet Functions |