☰ Menu

My Online Training Hub

Microsoft Office Online Training

Get our newsletter and join over 130,000
people who learn Excel with us every week
You are here: Home / Find Column Name | General Excel Questions & Answers | Excel Forum

Find Column Name | General Excel Questions & Answers | Excel Forum

Avatar
sp_Registration Register sp_LogInOut Log In sp_ControlOpen Unanswered
sp_Search Search
Advanced Search
Search

— Forum Scope —





— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
sp_RankInfo

Lost password?
sp_PrintTopic sp_TopicIcon
Find Column Name
Avatar
amisandip
Member
Members
Level 0
Forum Posts: 15
Member Since:
June 27, 2016
sp_UserOfflineSmall Offline
1
August 6, 2016 - 11:50 am
sp_Permalink sp_Print sp_EditHistory

Say, for number 3, we know column name is C or for number 27, column name is AA. Is there any smart way to get to know the column number for any number provided?

sp_AnswersTopicSeeAnswer See Answer
Avatar
SunnyKow
Malaysia

VIP
Members

Dashboards
Level 7
Forum Posts: 1282
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
2
August 6, 2016 - 12:37 pm
sp_Permalink sp_Print

You could try this

=SUBSTITUTE(ADDRESS(1,<your column number>,4),"1","")

sp_AnswersTopicAnswer
Answers Post
Avatar
amisandip
Member
Members
Level 0
Forum Posts: 15
Member Since:
June 27, 2016
sp_UserOfflineSmall Offline
3
August 6, 2016 - 5:30 pm
sp_Permalink sp_Print

Bang on Sunny! Brilliant!

Go to top
Forum Timezone: Australia/Brisbane

Most Users Ever Online: 107

Currently Online: Waqas Munir
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1282

Anders Sehlstedt: 332

Frans Visser: 319

David_Ng: 188

Velouria: 126

A.Maurizio: 124

Aye Mu: 114

Alison Banks: 107

Anne Walsh: 97

mymalone: 84

Newest Members:

Sue Hutchins

carrie lu

p p

Frank Sun

Craig Miller

Katie Kuiper

Abhishek Nehe

nhamoinesu tsvangirayi

Divin D

zim gregorio

Forum Stats:

Groups: 2

Forums: 22

Topics: 2507

Posts: 11238

 

Member Stats:

Guest Posters: 4

Members: 51991

Moderators: 1

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea

Moderators: Genevieve Tupas

YouTube Channel Follow us on Facebook Twitter Follow RSS Feed or Email
Excel Resources
Become an Affiliate
Secured by Sucuri Rect
✕
Hang On, Don't Go Just Yet.
Excel Tips & Tricks Book

As a thank you for visiting how would you like a
10% Discount Code to use with any of my courses?

I'll also give you a copy of my eBook packed with
100 Excel Tips & Tricks.

And I'll send you my weekly Excel blog posts.

Enter your email address below to receive all of these.

Regards, Mynda (Excel MVP)

mynda treacy mvp
100% Privacy. We don't spam.
✕
SUBSCRIBE AND LEARN EXCEL
Excel Tips & Tricks Book


Learn great Excel features, tips and tricks each week from my newsletter.

Just enter your email below, and as an extra bonus, I'll send you a copy of my '100 Excel Tips & Tricks eBook' - for nothing!

Thanks,

Mynda

 



100% Privacy. We don't spam.
✕
100 FREE EXCEL TIPS & TRICKS
Excel Tips & Tricks Book


Want to learn more great Excel tips and features?

Enter your email below and I'll send you my weekly blog post.

Plus, by signing up you'll get a copy of my '100 Excel Tips & Tricks eBook' - for nothing!




 

100% Privacy. We don't spam.