Compare Columns

Hello people,

I need help with a code does following:

loops through Column J and K
if the values are equal on the same row
select the Value in Column B and (same row) divided by the value in Column AB (same row) and present the new value -1 in the Column T

and if there is no value in column B after you find same value in J and K skip. that and continue loop

Could someone help me?

Thank you in advance

Please Login or Register  to view this content.

or may be inside loop use also i (not j) to have output in the same row, but then why macro, while formula would do this easily.

I got this code now

Please Login or Register  to view this content.

The problem is...

it says T is missmatch ( I meant of course Column T)

Where?
its important info not just

there says its missing a ")"

it's probably here:

Please Login or Register  to view this content.

by the way change also here

Please Login or Register  to view this content.

Hi,
values in J and K columns are not responsible for

Division by zero

column AB is.