How do I change the value of an attribute?

Change value in a column based on another column's value.

• QUESTION: Sixthsense, i dont know much about excel, but i need to change a value in column M to zero when column K value is greater than 100. Otherwise the value in column M stays the same. i have a workseet with about 9000 entries and need this done automatically, somehow.... thank you ! george. ANSWER: It cannot be possible inworksheet functions unless you use a helper column. It can be achieved using macro, but I have created a sample file for you and I have provided solution using worksheet function with the help of helper column. I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file. http://www.sendspace.com/file/7k4azo Scroll the mouse button to the bottom of the website and click Download The File Name is: EXAMPLE FILE.xls Hope it's Clear to you! ---------- FOLLOW-UP ---------- QUESTION: That works; but really it cannot be done without the helper column? i would love to have the values replaced directly in my column M.

• Answer:

  If you want to replace it directly in the same cell itself then you should go for VBA (macro) solution and no other go in excel. If you are looking for macro solution You might try one of the otherexperts that claim expertise inVBA such as Bob Umlas, Tom Oligvy, Stuart Resnik, Jan Pieterse or Aiden Heritage. I know they have provided excellent solutions from my personal observations. I am not proficient in VBA and therefore can not answer this question and the same is mentioned in my profile page also.