Macros program to match and find difference between two values

[puppy26]

Hi Guys.,
I got stuck into a problem while using Macros. I would like to find the difference of two values in the same column if the particular criteria matches..

Actually i was trying in Excel using the formula =IF(($V$2=V3)=TRUE,J3-$J$2,"").

Could some one hlep me with macros program as I'm not an IT guy.

 

[JackDanIce]

Not sure what you mean by using macro's, maybe you can post your code? The formula, I think should be:

=IF($V$2=V3,J3-$J$2,"")

 

[puppy26]

Macros Program to find the difference of two values

Hi Guys.,
I got stuck into a problem while using Macros. I would like to find the difference of two values in the same column if the particular criteria matches..

Actually i was trying in Excel using the formula =IF(($V$2=V3)=TRUE,J3-$J$2,"").

[TABLE="width: 144"]


<colgroup><col style="width: 48pt;" span="3" width="64">
<tbody>[TR]

[TD="width: 64, bgcolor: transparent"]City[/TD]

[TD="width: 64, bgcolor: transparent"]Temperature [/TD]

[TD="width: 64, bgcolor: transparent"]Difference[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]India[/TD]

[TD="bgcolor: transparent"]50[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]India[/TD]

[TD="bgcolor: transparent, align: right"]30[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]India[/TD]

[TD="bgcolor: transparent, align: right"]40[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]India[/TD]

[TD="bgcolor: transparent, align: right"]45[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]Germany [/TD]

[TD="bgcolor: transparent"]10[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]Germany[/TD]

[TD="bgcolor: transparent, align: right"]2[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]Germany[/TD]

[TD="bgcolor: transparent, align: right"]5[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]

[TR]

[TD="bgcolor: transparent"]Germany[/TD]

[TD="bgcolor: transparent, align: right"]3[/TD]

[TD="bgcolor: transparent"][/TD]

[/TR]


</tbody>[/TABLE]

This is an example.. so if the criteria India matches, it should find the difference between 50 and 30, 50 and 40, 50 and 45 and if the criteria Germany matches, it should find the difference between 10 and 2, 10 and 5, 10 and 3.

Could some one hlep me with macros program as I'm not an IT guy.

 

[Andrew Poulsom]

Re: Macros Program to find the difference of two values

Try this formula in row 2 copied down:

=IF(COUNTIF(V$2:V2,V2)>1,J2-INDEX(J:J,MATCH(V2,V:V,FALSE)),"")

 

[puppy26]

Re: Macros Program to find the difference of two values

@Andrew::
Thanks a lot.. It works so perfect..

 

[puppy26]

Re: Macros Program to find the difference of two values

Hi Andrew,
Could you please explain me the formula to understand better!

thanks in advance for your feedback..

 

[Andrew Poulsom]

Re: Macros Program to find the difference of two values

First the formula checks that the entry in column V is not the first one. If so it subtracts the first value in column J for that entry from the value in the current row of column J. Otherwise it returns null.

 

[Joe4]

Re: Macros Program to find the difference of two values

I have merged your two threads together. In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: </SPAN>Forum Rules).</SPAN>

Thanks