ExcelBanter - return a collum heading

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - return a collum heading (https://www.excelbanter.com/excel-worksheet-functions/118419-return-collum-heading.html)

ABCBAC

return a collum heading

Dear all,

How can my formulas return collum heading of specific current cell

Thanks for help
Bac

Bob Phillips

return a collum heading

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)

"ABCBAC" wrote in message
oups.com...
Dear all,

How can my formulas return collum heading of specific current cell

Thanks for help
Bac

All times are GMT +1. The time now is 07:08 AM.