Prev: Conditional Format With Wildcard
Next: Data Validation, Via A Formula
From: teri on 24 Feb 2010 17:46
I need to compare two worksheets -- duplicate data entry -- and find only the
cases where the two worksheets don't match. The simple case below would seem
to apply, but I'm not familiar with conditional formatting. Could someone
walk me through this? Where exactly do I enter that formula?

Thanks,
teri

"joel" wrote:

>
> When comparing two different worksheets depending on the data depends on
> how you would do the comparison
>
> 1) The simple Case - the two worksheets always have the save number of
> rows and you are comparing the data in the same row on each sheet. Here
> you can us conditional formating to compare the two sheets. Use a
> formula like this
>
> Sheet1!Q1 : put formula =Sheet2!Q1
> Sheet2!Q1 : put formula =Sheet1!Q1
>
>
> 2) If your data has different number of rows or the data is in a
> different order then you need a unique ID number so you can compare the
> two sheets.. Again you can use conditional formating but us a vlookup
> for comparison
>
> Assume a Unique ID is in column A.Vlookup will return NA is the ID
> isn't found
> Sheet1!Q1 : put formula =NOT(ISNA(VLOOKUP(A1,Sheet2!A1:Q10,17)))
> Sheet2!Q1 : put formula =NOT(ISNA(VLOOKUP(A1,Sheet1!A1:Q10,17)))
>
> If you want to compare values
> Sheet1!Q1 : put formula =Q1=VLOOKUP(A1,Sheet2!A1:Q10,17)))
> Sheet2!Q1 : put formula =Q1=VLOOKUP(A1,Sheet1!A1:Q10,17)))
>
>
> 3) If you have different number of rows and don't have an ID column
> then you are out of luck.
>
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=151080
>
> [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
>
> .
>
 | 
Pages: 1
Prev: Conditional Format With Wildcard
Next: Data Validation, Via A Formula