Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing multiple ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Problem with graph ranges | Charts and Charting in Excel | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |