How do I compare data in two worksheets to find matching cells?

[Gary]

Each day I work with two worksheets. One is a list of numbers that is given
to me by someone else. The other list is something I make myself, again it is
a list of numbers. I need to know if there is a way I can compare the data to
find out if any of the numbers I input on my list match up to the ones on the
list I am given. I am aware of the "Find" function, but I'm working with
lists of hundreds of numbers, and it's really annoying to take each one and
"find" it on another worksheet. Any answers?

[Norman Jones]

Hi Gary,

See Chip Pearson's Tagging Duplicates page. In particular, look at :

Extracting Values Common To Two Lists
and
Extracting Values On One List And Not Another

near the foot of the page:

http://www.cpearson.com/excel/duplic...gingDuplicates


---
Regards,
Norman



"Gary" <[email protected]> wrote in message
news:[email protected]...
> Each day I work with two worksheets. One is a list of numbers that is
> given
> to me by someone else. The other list is something I make myself, again it
> is
> a list of numbers. I need to know if there is a way I can compare the data
> to
> find out if any of the numbers I input on my list match up to the ones on
> the
> list I am given. I am aware of the "Find" function, but I'm working with
> lists of hundreds of numbers, and it's really annoying to take each one
> and
> "find" it on another worksheet. Any answers?

[JE McGimpsey]

Take a look at

http://cpearson.com/excel/duplicat.htm

In article <[email protected]>,
"Gary" <[email protected]> wrote:

> Each day I work with two worksheets. One is a list of numbers that is given
> to me by someone else. The other list is something I make myself, again it is
> a list of numbers. I need to know if there is a way I can compare the data to
> find out if any of the numbers I input on my list match up to the ones on the
> list I am given. I am aware of the "Find" function, but I'm working with
> lists of hundreds of numbers, and it's really annoying to take each one and
> "find" it on another worksheet. Any answers?

[woodlot4]

I don't know if I am off base here or not but I am looking for a similar formula to compare two different lists of information. Chip's info seems to discuss only how to compare for duplicate in one column. What I see being asked here and what I wish to have is a formula that will compare column b in worksheet 1 with column b in worksheet 2 and let me know if there are any duplicate names or details.

the links to Chips info do not help with this.
Does anyone have some better helps or options? I had one once but can't seem to find it now.

[Dave Peterson]

You could use an additional column (C) in both worksheets.

Then put this type of formula in C1:

=isnumber(match(b1,'sheet2'!b:b,0))
and drag down

Change the sheet name to match the other sheet (huh?).

Then drag down.

You'll end up with a column True/false. True means there was a match.

woodlot4 wrote:
>
> I don't know if I am off base here or not but I am looking for a similar
> formula to compare two different lists of information. Chip's info
> seems to discuss only how to compare for duplicate in one column. What
> I see being asked here and what I wish to have is a formula that will
> compare column b in worksheet 1 with column b in worksheet 2 and let me
> know if there are any duplicate names or details.
>
> the links to Chips info do not help with this.
> Does anyone have some better helps or options? I had one once but
> can't seem to find it now.
>
> --
> woodlot4
> ------------------------------------------------------------------------
> woodlot4's Profile: http://www.excelforum.com/member.php...o&userid=26613
> View this thread: http://www.excelforum.com/showthread...hreadid=333388

--

Dave Peterson