Autofilltering and applying formula in other column

[mogss_04]

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

Material Code Unit Price in FC Varaition in Base Price 000000000001000392 45.77 000000000001000392 45.77 =IF(1-(B3/$B$2)=0,"OK",-1*(1-(B3/$B$2))) 000000000001000392 45.77 =IF(1-(B4/$B$2)=0,"OK",-1*(1-(B4/$B$2))) 000000000001000392 45.77 =IF(1-(B5/$B$2)=0,"OK",-1*(1-(B5/$B$2))) 000000000001000392 45.77 =IF(1-(B6/$B$2)=0,"OK",-1*(1-(B6/$B$2))) 000000000001000392 45.77 =IF(1-(B7/$B$2)=0,"OK",-1*(1-(B7/$B$2))) 000000000001000392 45.77 =IF(1-(B8/$B$2)=0,"OK",-1*(1-(B8/$B$2))) 000000000001000392 45.77 =IF(1-(B9/$B$2)=0,"OK",-1*(1-(B9/$B$2))) 000000000001000393 10.16 000000000001000393 10.16 =IF(1-(B11/$B$10)=0,"OK",-1*(1-(B11/$B$10))) 000000000001000393 10.16 =IF(1-(B12/$B$10)=0,"OK",-1*(1-(B12/$B$10))) 000000000001000393 10.58 =IF(1-(B13/$B$10)=0,"OK",-1*(1-(B13/$B$10))) <colgroup><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thank you

<tbody>
</tbody>

 

[mogss_04]

Can somebody please help me with above

 

[mogss_04]

bump