return a collum heading

A

ABCBAC

Dear all,

How can my formulas return collum heading of specific current cell

Thanks for help
Bac
 
B

Bob Phillips

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