G
Guest
i am struggling to find an easy way to get all the orders containing ONLY
product A and B. Here is the kind of spreadsheet i have:
Column A Column B Column C
Order# Product Quantity
00001 A 3
00001 B 4
00001 C 5
00002 A 1
00003 B 3
00003 C 1
00004 A 3
00004 B 4
00004 C 4
I want to get just the orders that contain product A and B (basically 00001
and 00004). Can't do it with my pivot without creating an additional column
and extracting the orders that contain A and B, not elegant and time
consuming. I am sure excel has something built-in that allows you to do that
quickly. Am I missing something?
thank you,
product A and B. Here is the kind of spreadsheet i have:
Column A Column B Column C
Order# Product Quantity
00001 A 3
00001 B 4
00001 C 5
00002 A 1
00003 B 3
00003 C 1
00004 A 3
00004 B 4
00004 C 4
I want to get just the orders that contain product A and B (basically 00001
and 00004). Can't do it with my pivot without creating an additional column
and extracting the orders that contain A and B, not elegant and time
consuming. I am sure excel has something built-in that allows you to do that
quickly. Am I missing something?
thank you,