Thread: Formula to Return Column Heading
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Formula to Return Column Heading
Where C1:G1 are your headers and data starting in row 2, the formula in
B2 is
=IF(C2<0,C$1,IF(D2<0,D$1,IF(E2<0,E$1,IF(F2<0,F $1,G$1))))

Reply With QuoteReply With Quote