Find difference(latency) between two rows in certain column

[Bobbyiffor]

Hi All,

write down macro or combination of formulas to find out the following-

I need to find the difference between certain column in 2 rows based on other columns.

For example-

Find 'A10' minus 'A16' based on certain values in B column. 'B1' or 'B2' or 'B10' or 'B?' ('B' can be anything).

Once you find the difference, copy/paste it as comment or paste it in blank column anywhere in the worksheet.

How to determine which 'A?' to minus from which 'A?'
For that, determine B column.

How do you choose B? value?
For that, Find B? = B? . The pattern looks like
B1= B2 = B10 (most of the time)
or
B1= B2 = B10= B114

Now highlight/choose B10 value; we don't need B1 and B2 here. Now choose A10. Now, (check another column C) if C10= C11 then deduct A10 from A11. this is the value we need and we want to paste it.

or
Now highlight/choose B10 and B114 value; we don't need B1 and B2 here. Now choose A10 and A114. (Note: Don't subtract A10 with A114)
Now, (check another column C) if C10= C11 then deduct A10 from A11 and if C114= C115 then deduct A114 from A115. these are the values we need and we want to paste it as comment or in blank cloumn.