Autofilltering and applying formula

[mogss_04]

Hi All,

I have cross posted the below question on another Excel Forum as well.Not able to include the link to orginal forum since posting for first time. Have not received any response there . Hence posting here.

Would request someone to guide me on below.


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)))

Thank you

[Pepe Le Mokko]

Please tell us on which other forum you cross posted.
Thanks

[mogss_04]

MrExcel.com

[JeteMc]

Hello mogss_04 and Welcome to Excel Forum.
I believe this is the link.
https://www.mrexcel.com/forum/excel-...tml?highlight=
I suggest that you apply the following formula to C2 and copy down:

Please Login or Register  to view this content.

For future reference you will usually get faster results if you upload a sample spreadsheet by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
I have included a sample file for you in this instance.
Let us know if you have any questions.