Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gary
 
Posts: n/a
Default How do I compare data in two worksheets to find matching cells?

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?
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

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" wrote in message
...
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?



  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Take a look at

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

In article ,
"Gary" 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
woodlot4
 
Posts: n/a
Default How do I compare data in two worksheets to find matching cells?


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

  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I compare data in two worksheets to find matching cells?

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 06:33 PM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 07:15 PM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"