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



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

[TABLE="width: 847"]
<tbody>[TR]
[TD]Thank you[/TD]
[/TR]
</tbody>[/TABLE]

 

[mogss_04]

Can somebody please help me with above

 

[mogss_04]

bump