title: excel formula to get the latest timestamp of latest updated cell in a particular row
body: <p>I need a formula in MS Excel to get the last updated timestamp everytime any cell in a particular row is updated.I am using<br> <code>=if($2:$2="","",NOW())</code> <br>but when one cell is updated, every cell even of other row having similar formula is updated with the latest time-stamp. What can be the problem?</p>
  
  <p>I need only formula not a macro/excel program.</p>