Yusuf
Active Member
- Joined
- Jun 1, 2004
- Messages
- 337
Hi all
I have a spreadsheet that has two columns (A & B) with the first containing account numbers and the second containing many item IDs for three different kinds of items.
I know what the items are because of what the IDs start with
eg; pen = 0011..., pencil = AAA.. and paper = 75...
Because the items appear in only one column, if one account had all three items then the Account number would appear thrice in column A and have the item IDs beside it.
My predicament,
I have been tasked to remove all the Paper Only accounts.
This means that I have to overlook the Accounts that contain Paper and something(s) else.
I am totally struggling with this one and would appreciate any help you might have with this
I have a spreadsheet that has two columns (A & B) with the first containing account numbers and the second containing many item IDs for three different kinds of items.
I know what the items are because of what the IDs start with
eg; pen = 0011..., pencil = AAA.. and paper = 75...
Because the items appear in only one column, if one account had all three items then the Account number would appear thrice in column A and have the item IDs beside it.
My predicament,
I have been tasked to remove all the Paper Only accounts.
This means that I have to overlook the Accounts that contain Paper and something(s) else.
I am totally struggling with this one and would appreciate any help you might have with this