JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have a table (20 rows, 3 columns) with various data. I have 20 other cells with if statements that will result in 2 possible options, for example either AAA-1 or AAA-2 will be the result of the if statement. Not all the if statements are completed at the same time. What I am asking is when and IF statement comes up with an answer say AAA-2 I am looking to delete all the "AAA-2" from the 20 row 3 column table and do so every time an if statement comes up with one of it 2 possible answers.
AAA-1 AAA-3 AAA-2
AAA-2 AAA-1 AAA-4
AAA-3 AAA-2 AAA-5
I am looking for the result of
AAA-1 AAA-3
AAA-1 AAA-4
AAA-3 AAA-5
Thank you,
James
AAA-1 AAA-3 AAA-2
AAA-2 AAA-1 AAA-4
AAA-3 AAA-2 AAA-5
I am looking for the result of
AAA-1 AAA-3
AAA-1 AAA-4
AAA-3 AAA-5
Thank you,
James