How do I name rows and columns in an array

  • Thread starter Thread starter Gulfman100
  • Start date Start date
G

Gulfman100

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
 
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
 
Back
Top