Automaticaly Define Name From Row Column Head

[dlmandalia]

Hi I wanted to define names automaticly from Row Column Head


Example

Ahmedabad Bombay Kolkata

Apple 10 14 17

banana 11 15 18

Orange 13 16 19


I want to automaticaly define name for 10 as AhmedabadApple, 11 as AhmedabadBanana, 14 as BombayApple so and so forth.


I don't know how to do that. Please help me on it.


Dipen Mandalia

 

[Hui]

@Dipen


Firstly, Welcome to the Chandoo.org forums.


Select the Cells including Header Row

Formulas Ribbon

Create From Selection

Tick Top Row only

Apply


Excel will add _ if there are spaces in the Text of the Top Row

so "My Header" will appear as "My_Header"

 

[Debraj]

Hi Dipen,


Just to make it more clear..

You have to select the range, before click > Formula > Define Names > Create From Selection or (Alt + I + N + C)


You have select both checkbox:

Top Row and [code]Left Column


Finally : And you need to type =Ahmedabad Apple

(space is required) to get answer 10

or =Sum(Banana)[/code] to get answer 44..