return a collum heading

  • Thread starter Thread starter ABCBAC
  • Start date Start date
A

ABCBAC

Dear all,

How can my formulas return collum heading of specific current cell

Thanks for help
Bac
 
Assuming the activecell is B7, then

=OFFSET(B7,-ROW(B7)+1,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a value in a cell when 2 others cell match a certain cri 3
iam not able to find CONTACT PERSON collum in my exel work sheet 1
Pivot Table 1
conting cells? 2
count function problem 4
Vlookup returns line number 1
sum of a cell if 2 cells meet a condition 4
My accounting program is a penny off, Why? 2

Back
Top