Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet that contains vendor information for our
different locations. In column B have the vendor P/N listed and in column A we have our P/N's listed for each vendor P/N. We have different P/N's that have the same vendor P/N. I need to find out where the vendor number is the same in column B and the P/N's are different in column A. Here is an example of what I'm talking about. The vendor P/Ns in cells B2 & B3 are the same, but our P/N's in cells A2 & A3 are different. I have about 3,000 entries to go through. A B 1 Our P/N Vend P/N 2 365181 11003 3 518136 11003 4 119706 11007 5 706119 11007 6 76873 13005 7 73768 13005 8 119546 23114 9 645911 23114 10 357501 27518 11 357501 27518 12 100722 27685 13 357587 27685 14 122690 27714 15 122690 27714 16 137710 28655 17 137710 28655 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statements | Excel Worksheet Functions | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
IF and MAX statements | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions | |||
If statements | Excel Discussion (Misc queries) |