Hello,
Looking for a formula that will display a non-duplicate value from a range of values excluding values in another range.
Publications is a static, alphabetically sorted range in Workbook1. (Actual list is 40 rows.)
A
1 Publications
2 AAA Westways
3 Business Week
4 Money
5 National Geographic
6 New York Times
7 Newsweek
8 People
9 Reader's Digest
10 Smithsonian
Ads Placed is a dynamically generated range (from Workbook2) in Workbook3.
D
11 Ads Placed
12 Reader's Digest
13 Business Week
14 People
15 National Geographic
16 Money
17 [want AAA Westways to appear here]
18 [want New York Times to appear here]
19 [want Newsweek to appear here]
20 [want Smithsonian to appear here]
Need to identify the missing publication names in Ads Placed (from Publications) and generate using formulas (not macros). Can be in a different column if needed.
Is this enough detail? Thanks for any help!!
Looking for a formula that will display a non-duplicate value from a range of values excluding values in another range.
Publications is a static, alphabetically sorted range in Workbook1. (Actual list is 40 rows.)
A
1 Publications
2 AAA Westways
3 Business Week
4 Money
5 National Geographic
6 New York Times
7 Newsweek
8 People
9 Reader's Digest
10 Smithsonian
Ads Placed is a dynamically generated range (from Workbook2) in Workbook3.
D
11 Ads Placed
12 Reader's Digest
13 Business Week
14 People
15 National Geographic
16 Money
17 [want AAA Westways to appear here]
18 [want New York Times to appear here]
19 [want Newsweek to appear here]
20 [want Smithsonian to appear here]
Need to identify the missing publication names in Ads Placed (from Publications) and generate using formulas (not macros). Can be in a different column if needed.
Is this enough detail? Thanks for any help!!
