Excel Formula using =[@[textincell]]/12

KSkipper

New Member
Joined
Dec 6, 2013
Messages
7
I received an Excel workbook from someone and when I'm looking at it I see they are using formulas like
=[@[prior_year_usage]]/12 (where prior_year_usage is text entered as the column header (row 1)).

I've never seen that. Can anyone explain how that is done?
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

KSkipper

New Member
Joined
Dec 6, 2013
Messages
7
Thank you for the reply. I've learned something today. I don't normally use Tables. I will have to try using them on occasion.
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
You're welcome.

They are both a blessing and a curse..
Lots of handy and cool features about them.
But learning and using that structured reference style is a pain.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,951
Messages
5,525,833
Members
409,666
Latest member
aquabit

This Week's Hot Topics

Top