LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Compare two lists

I have two lists of part numbers and I need to know whether there are numbers
in one list that are missing from the other. Using Excel Help, I found an
article on microsoft .com he
http://office.microsoft.com/en-us/ex...CL100570551033
Steps 2 and 3 of the article seem helpful, but I am trying to understand the
forumlae. Surely when comparing data on two different worksheets, you would
expect to see the worksheet name in the formula? I didn't see anywhere in the
procedure to combine the two lists onto a single worksheet.
Has anybody used this article for a similar purpose?
--
Richard

Search the web and raise money for charity at www.everyclick.com
 
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
Compare two lists ExcelInExcel Excel Discussion (Misc queries) 2 June 8th 07 09:09 PM
Compare two lists Vicki Needs Help New Users to Excel 1 May 11th 07 03:46 AM
compare name lists deo89 Excel Worksheet Functions 1 February 1st 07 01:55 AM
Compare Lists Lemmesee Excel Discussion (Misc queries) 5 January 9th 07 03:15 AM
compare two lists rob p Excel Worksheet Functions 3 October 10th 05 07:01 PM


All times are GMT +1. The time now is 12:48 AM.

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

About Us

"It's about Microsoft Excel"