Prev: Calculating date/time intervals??
Next: Invisible Column names and Row numbers
From: Pradeep_ji78 on 28 May 2010 13:49
I have old code and old description in my excel. Now company given me new
code with same description. I want to compare the old code with new code but
description is same. how to compare?

regards,
pradeep.K
From: Luke M on 28 May 2010 15:53
Lets say your old data is in A:B and new data is in C:D (with description in
A and C)

In E1:
=VLOOKUP(C1,A:B,2,FALSE)

This will find the old code. If you want to highlight where changes have
occured:
=VLOOKUP(C1,A:B,2,FALSE)=D1



--
Best Regards,

Luke M
"Pradeep_ji78" <Pradeep_ji78(a)discussions.microsoft.com> wrote in message
news:5861DF32-40AB-4F23-A21F-083FF520343E(a)microsoft.com...
>I have old code and old description in my excel. Now company given me new
> code with same description. I want to compare the old code with new code
> but
> description is same. how to compare?
>
> regards,
> pradeep.K


From: Gord Dibben on 28 May 2010 16:51
Print both sets of code and compare side by side?


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 10:49:03 -0700, Pradeep_ji78
<Pradeep_ji78(a)discussions.microsoft.com> wrote:

>I have old code and old description in my excel. Now company given me new
>code with same description. I want to compare the old code with new code but
>description is same. how to compare?
>
>regards,
>pradeep.K

 | 
Pages: 1
Prev: Calculating date/time intervals??
Next: Invisible Column names and Row numbers