LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 8
Default IF THEN STATEMENTS

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
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
If statements Bob Excel Worksheet Functions 1 February 20th 08 01:18 PM
IF Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
IF and MAX statements bob Excel Worksheet Functions 5 April 2nd 06 04:33 AM
If statements kieffer Excel Worksheet Functions 8 February 22nd 06 03:19 PM
If statements paule1982 Excel Discussion (Misc queries) 4 February 18th 06 05:09 PM


All times are GMT +1. The time now is 11:48 PM.

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"