Comparing two cells
 

Hi,

I have same data in column A and column B, but in column B the data in not
in the same sequence as that in column A.

I want a formula which identifies if there is any difference in data of
column A with that of column B, if there is any difference then the same
should be highlighted.

Hope to here the formula for the same soon......

Cheers,
Mandeep

Comparing two cells
 

"Mandeep Dhami" wrote:
.. same data in column A and column B,
but in column B the data in not in the same sequence
as that in column A.
.. a formula which identifies if there is
any difference in data of column A with that of column B,
if there is any difference
then the same should be highlighted.

Here's one way to highlight items in col A
which are not in col B via conditional formatting

Select col A
Click Format Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND(NOT(ISNUMBER(MATCH(A1,$B:$B,0))),A1<"")
Click Format button Patterns tab Brown? OK
Click OK at the main dialog

The above will return the required highlights in col A ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Comparing two cells
 

One way:

Put in column C and copy down:

=IF(COUNTIF(A1:A20,"="&B1)=0,"Missing",IF(COUNTIF( A1:A20,"="&B1)1,"Duplicated",""))


HTH

"Mandeep Dhami" wrote:

Hi,

I have same data in column A and column B, but in column B the data in not
in the same sequence as that in column A.

I want a formula which identifies if there is any difference in data of
column A with that of column B, if there is any difference then the same
should be highlighted.

Hope to here the formula for the same soon......

Cheers,
Mandeep