Hi All,
I have three columns. Column A - ID , Column B - Price and Column C = Variation In Price.
I need to first filter column A for one ID, then apply the formula in the second visible cell in Column C not counting the header - =IF(1-(B3/$B$2)=0,"OK",-1*(1-(B3/$B$2))) and drag this formula across all visible cells for all the duplicate IDs.
I need to do this for every ID. currently it is happening this way. How can we automate this procedure.Can Somebody please guide me on below
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
I have three columns. Column A - ID , Column B - Price and Column C = Variation In Price.
I need to first filter column A for one ID, then apply the formula in the second visible cell in Column C not counting the header - =IF(1-(B3/$B$2)=0,"OK",-1*(1-(B3/$B$2))) and drag this formula across all visible cells for all the duplicate IDs.
I need to do this for every ID. currently it is happening this way. How can we automate this procedure.Can Somebody please guide me on below
<colgroup><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thank you |
<tbody>
</tbody>