zookeepertx
Well-known Member
- Joined
- May 27, 2011
- Messages
- 576
- Office Version
- 365
- Platform
- Windows
A | B | I | Z | AA | AB | AC |
Once | fine | Once | ||||
Same | Double | Twice | ||||
Same | Double | Same | ||||
Different | New | Third | ||||
Fourth | Match | Different | ||||
Fourth | Match | Fourth | ||||
Fourth | Normal | Five | ||||
Fourth | Opposite | Sixth | ||||
Help | Sign | Apple | ||||
Help | Street | Help | ||||
<tbody>
</tbody>
A | B | I | Z | AA | AB | AC |
Once | fine | Once | fine | |||
Twice | ||||||
Same | Double | Same | Double | |||
Third | ||||||
Different | New | Different | New | |||
Fourth | Match | Fourth | Match | Normal | Opposite | |
Five | ||||||
Sixth | ||||||
Apple | ||||||
Help | Sign | Help | Sign | Street | ||
<tbody>
</tbody>
I've been working on this for just about ever and am SICK of looking at it! Please help!
I need to find the data from column I in column A and - in the simplest case - return the data in column B into column Z.
* If there's no match in A for I, move all of columns A:B down - (ultimately, to where there IS a match in A for I).
* If there's 1 match in A for I, return data from B into column Z.
-If the row # in A isn't "level with" the row # it's matched with in I
~Move all of columns A:B down to where they are "level with" the row in I that A is matched with.
* If there are 2 matches in A for I, then:
-If B on the first row = B on the second row, return data from the first row where A matched, into Z.
-Delete A:B of the second matched A
-Move all of columns A:B down to where they are "level with" the row in I that A is matched with.
-If B on the second row <> B on the first row, return the first B into Z and the second B into AA.
-Delete A:B of the second matched A
-Move all of columns A:B down to where they are "level with" the row in I that A is matched with.
*If there are more than 2 matches in A for I, then:
-Return data from the first row where A matched into Z.
-If B on the subsequent rows = B on any of the above rows, then ignore the data in THAT B only.
-If B on the first row <> B on any of the above rows, return each subsequent non-duplicated B into the columns after Z.
-Delete A:B of all of the matched A's after the first one.
-Move all of columns A:B down to where they are "level with" the row in I that A is matched with.
MAN, this is hard to explain with words!! I hope I've made some sense!
The tables above show a small version of the original and then a small version of the desired result.
I hope someone can figure this out for me, because I'm getting nowhere fast!
Thanks
Jenny