Good Day All;

I have 2 Excell works sheets with approx 14000 rows each. What I would like
to do is compare both lists and get a 3rd list that shows what entries do not
match.
Is there a simple way to do ythis in Excel

Thanks All
Chomp

Assuming A1 should equal A1 in the other sheet...

=IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1)

Auto-Filter for non-blanks.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"The Chomp" wrote:

> Good Day All;
>
> I have 2 Excell works sheets with approx 14000 rows each. What I would like
> to do is compare both lists and get a 3rd list that shows what entries do not
> match.
> Is there a simple way to do ythis in Excel
>
> Thanks All
> Chomp
>

Thank you very much Luke

"Luke M" wrote:

> Assuming A1 should equal A1 in the other sheet...
>
> =IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1)
>
> Auto-Filter for non-blanks.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "The Chomp" wrote:
>
> > Good Day All;
> >
> > I have 2 Excell works sheets with approx 14000 rows each. What I would like
> > to do is compare both lists and get a 3rd list that shows what entries do not
> > match.
> > Is there a simple way to do ythis in Excel
> >
> > Thanks All
> > Chomp
> >