Here goes...not sure if this can be done but you guys are the experts so
thought I'd ask!! We have six columns, DA - DF and we want the formula in
DG. The first three columns repeat themselves in the last three. The first
three are titled "Season 0", "Season 1", and "Season 2" and are in DA-DC and
repeat themselves in DD-DF, giving us our six columns. Within those six
columns we have ID numbers for people, in no particular order in any of the
six columns. We want the formula in DG to look in column BT, pull that ID #
out and search for it in one of the six columns mentioned earlier, DA-DF.
Here is where it gets tricky. I mentioned that the six columns just repeat
themselves, Season 0, Season 1, Season 2, Season 0, Season 1, Season2. While
the formula is pulling the ID # from BT and searching in columns DA-DF, we
need to know exactly where it found them. For instance, if the ID # in BT
row 2 is 12345, and it finds it in any of the six columns, we need some
specifics. Any ID # found in the same seasons are acceptable, meaning if
12345 is found in Season 0 (DA) and Season 0 (DD), we just want the formula
to return something like "Good". If 12345 is found in only ONE of the
columns out of the six, that is also "Good". We are looking for 12345 found
in various seasons. If 12345 is found in Season 1 and Season 2 (doesn't
matter which 1 & 2 column), we want a formula return of "Bad". We need Excel
to look through all rows and columns in DA-DF, not just the row associated
with the formula. So if the first row is 2, we don't want the formula to
only look for 12345 in the six columns in row 2. We need it to look all the
way down to row 50,000 in ALL six columns. Basically, pull the ID # from
BT, look through thousands of cells with in six columns and return a "Good"
or "Bad". We are just trying to identify numbers that appear once in any of
the six columns (Good), numbers that appear more than once but within the
same seasons ("Good" and in both season 1 columns, or season 2 columns,...),
and numbers that appear more than once but in different seasons with a return
of "Bad" (12345 found in Season 1 column DB row 15,000 and 12345 found in
Season 0 column DD row 5, 423). Any help is appreciated as soon as possible.
Thanks!!