• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Replace cell value with column header if true

R

rawad077

New Member
Can someone show me how do I replace a cell value with its relevant column header if the value in the cell is 1? And if 0 do nothing
 
Welcome To Chandoo.


Can you explain us how your data is arranged?

Where are column headers located e.g. Row 1?

Do you want to do this on one column or all columns?


Explaining your situation accurately will help you get better solution / approach?
 
rawad077


If data in column A and header is A1 this in B2 =IF(A2>=1,"ColumnHeader",0)
 
You must log in or register to reply here.
Back
Top