Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lockwood7
 
Posts: n/a
Default How to : Comparing Two Ranges


I run an auto parts business. I have a list of parts in my excel data
base. When parts are sold throught the web, I need to download the
list and compare it to the list of parts in the database. Any parts
that no longer show on the web must be deleted from the list in excel.
How do I compare the two lists and view the exceptions? I thought I had
figured it out using the EXACT function, but it is not working
properly.

Thanks-
John


--
lockwood7
------------------------------------------------------------------------
lockwood7's Profile: http://www.excelforum.com/member.php...o&userid=25853
View this thread: http://www.excelforum.com/showthread...hreadid=392381

  #2   Report Post  
Steve Mackay
 
Posts: n/a
Default

Would help if you explained a little more about the format. However,
if the Web list is in Column A (I'm assuming 500 parts) and the
Database is in column B, then in C1 you could use this formula and copy
down to the the end of the list:

=countif(B1,$A$1:$A$500)

any cell with "0" you could delete.

  #3   Report Post  
Karthik
 
Posts: n/a
Default

Hi

You should use Vlookup function. To know more about how to use this
function please read the below page

http://office.microsoft.com/en-us/as...563201033.aspx

Thanks
Karthik Bhat
Bangalore

  #4   Report Post  
lockwood7
 
Posts: n/a
Default


Thank you for your quick replies. Your help has proven very valuable.

John


--
lockwood7
------------------------------------------------------------------------
lockwood7's Profile: http://www.excelforum.com/member.php...o&userid=25853
View this thread: http://www.excelforum.com/showthread...hreadid=392381

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
comparing multiple ranges Steve Excel Discussion (Misc queries) 1 April 27th 05 08:38 PM
Like 123, allow named ranges, and print named ranges WP Excel Discussion (Misc queries) 1 April 8th 05 07:07 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 02:09 PM
compare unique identifiers in multiple ranges bawilli_91125 Charts and Charting in Excel 1 November 30th 04 07:34 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM


All times are GMT +1. The time now is 05:22 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"