title: How to use **row()** function with **if()** statement in Excel-2010 to return the row number if value is *true*
body: <p>how to use <strong>row()</strong> function with <strong>if()</strong> statement in Excel-2010 to return the row number if value is <em>true</em>.
  If there is some other way with which I can do the same job it'll be appreciated too.
  The Job is: I have a range of data in a single column with multiple rows and the condition is "if the value of data is greater than 50" than I have to print all the desired data in another column with each data in a separate row. </p>
  
  <p>If this is possible with the <strong>row()</strong> and <strong>if()</strong> function, it's ok, any other methods' are also invited. </p>