Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I name rows and columns in an array
I have a named data base and want to name the rows columns and use those
names to return the intersecting value. I named the array without a problem, but I can't seem to get the rows & cols. named to use in a formula. I have 2003 with SP2 Thanks Dan |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I name rows and columns in an array
Dan,
Select the table with the row and column labels, and use Insert / Name / Create... and check "top row" and "left column" and click OK. Note that your labels should not have any spaces to create valid names for the intersect function. HTH, Bernie MS Excel MVP "Gulfman100" wrote in message ... I have a named data base and want to name the rows columns and use those names to return the intersecting value. I named the array without a problem, but I can't seem to get the rows & cols. named to use in a formula. I have 2003 with SP2 Thanks Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |