software

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

quot;Mandeep Dhamiquot; wrote:
gt; .. same data in column A and column B,
gt; but in column B the data in not in the same sequence
gt; as that in column A.
gt; .. a formula which identifies if there is
gt; any difference in data of column A with that of column B,
gt; if there is any difference
gt; 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 gt; Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND(NOT(ISNUMBER(MATCH(A1,$B:$B,0))),A1lt;gt;quot;quot;)
Click Format button gt; Patterns tab gt; Brown? gt; OK
Click OK at the main dialog

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

Put in column C and copy down:

=IF(COUNTIF(A1:A20,quot;=quot;amp;B1)=0,quot;Missingquot;,IF(COUNTIF( A1:A20,quot;=quot;amp;B1)gt;1,quot;Duplicatedquot;,quot;quot;))HTH

quot;Mandeep Dhamiquot; wrote:

gt; Hi,
gt;
gt; I have same data in column A and column B, but in column B the data in not
gt; in the same sequence as that in column A.
gt;
gt; I want a formula which identifies if there is any difference in data of
gt; column A with that of column B, if there is any difference then the same
gt; should be highlighted.
gt;
gt; Hope to here the formula for the same soon......
gt;
gt; Cheers,
gt; Mandeep