I have two (2) different issues that I need help with. This is question #1 or part 1, of 2 parts:
In the first scenario, I have three (3) columns of data: Originating, Terminating and one for the formula. I need to be able to search one (1) ROW at a time (not columns), and look for a specified value in EITHER A2 or B2. If the specified value does exist in one of those cells, I need to populate C2 (same row) with a value of "True" or blank. If the specified value does NOT exist in either A2 or B2, then I need C2 to be populated with "False"
ex: I'm looking for 0066 in EITHER A2 or B2. It doesn't exist in either cell, so I'd like C2 to say "False"
0066 does exist in A3, so I'd like C3 to either be blank or be populated with "True"
0066 does exist in B3, so I'd like C3 to either be blank or be populated with "True"
It is not uncommon for these particular spreadsheets to contain 60,000-70,000 rows of data, and numerous columns, so searching manually eats up man hours. What I've done in the past is a series of filters to get to the answer I need.
Ultimately, I'm trying to get to a point where I can delete all the rows where column F is False.
Bookmarks