Solved: Compare the values between two columns

[sindhuja]

Hi All,

Here is my Requirement !
I want to compare two columns Code and GL.
If the value of cell in GL column is CAP then the value of cell in Code should start with 1, similarly if GL value is TRS then Code value should start with 2 and similarly if GL value is R then the code value should start with 3.

The comparision should be on either column. If the above defined rules deviates then the entire row to be copied to sheet 2 of the same file as they are with different different values.

Also values in the code other than starting with either 1,2 or 3 needs to be deleted.

I have also attached the file for the reference.
Quick help will be highly helpful !!!

Thanks for all your help in advance...
-Sindhuja

[rbrhodes]

Hi sindhuja,

Like this?

[sindhuja]

Hi,

This is what i needed.

thanks for you help !

-Sindhuja

[sindhuja]

Hi,

Just an addition to my need...

For a single match ID, there should be same GL, same Fund ,same class...
If anything is different then, all the values should be retrieved and updated in the sheet2.

Attached the file for the reference...

-Sindhuja

[rbrhodes]

Hi,

I think i need more explanation!

Exactly what are we comparing?

What do you mean "...all the values should be retrieved and updated in the sheet2."

[sindhuja]

Sure Rhodes,

[sindhuja]

Sure Rhodes !

Here is the scenario...
We will match the values only when fund, gl and class is the same. If there is a difference in values then those must be retrieved and updated in the sheet 2.

In the below example, second line is the with the fund # 83 which is difference from others for a match ID, so that is to be retrieved. There is also exceptions cases where a single match ID can have different fund values provided gl must be RF.

Fund # Class GL Match
7 21000 TRS 7927342
83 21000 TRS 7927342
7 21000 TRS 7927342

Hope i made it clear...

-Sindhuja

[rbrhodes]

Thanks, I'll look at it

[sindhuja]

Hi,

Any comments on this please....

-Sindhuja

[sindhuja]

hi,

This is really a concern for me...
Please help me out in my requirement...

-Sindhuja

[rbrhodes]

Hi sindhuja,

I forgot about this one...long enought that a fresh look helpred me figure it out (I think). One question tho:

The original request was for three codes:

CAP = 1
TRS = 2
R = 3

Now you add RF:

"There is also exceptions cases where a single match ID can have different fund values provided gl must be RF"

Where does RF come from? The attached example will delete any rows that are RF because RF doesn't match CAP,TRS or R.

[sindhuja]

Hi,
Thanks for the heads up..!

The RF is same as R

And also I have highlighted the expected output
Need the data which is difference in a single match ID

Hope this will be clear..
-Sindhuja

[rbrhodes]

Hi Sindhuja,

This works on your example. It looks for "R" only so will handle "R" or "RF".

Try it out...