Dear all, How can my formulas return collum heading of specific current cell Thanks for help Bac
A ABCBAC Nov 11, 2006 #1 Dear all, How can my formulas return collum heading of specific current cell Thanks for help Bac
B Bob Phillips Nov 11, 2006 #2 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)
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)