zookeepertx
Well-known Member
- Joined
- May 27, 2011
- Messages
- 586
- Office Version
- 365
- Platform
- Windows
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]Z
[/TD]
[TD="align: center"]AA
[/TD]
[TD="align: center"]AB
[/TD]
[TD="align: center"]AC
[/TD]
[/TR]
[TR]
[TD]Once
[/TD]
[TD]fine
[/TD]
[TD]Once
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD]Twice[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD]Same
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Different
[/TD]
[TD]New
[/TD]
[TD]Third[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Different
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Fourth
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Normal
[/TD]
[TD]Five[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth[/TD]
[TD]Opposite
[/TD]
[TD]Sixth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Help
[/TD]
[TD]Sign
[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Help
[/TD]
[TD]Street
[/TD]
[TD]Help[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]Z
[/TD]
[TD="align: center"]AA
[/TD]
[TD="align: center"]AB
[/TD]
[TD="align: center"]AC
[/TD]
[/TR]
[TR]
[TD]Once
[/TD]
[TD]fine
[/TD]
[TD]Once
[/TD]
[TD]fine
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Twice[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Third[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Different[/TD]
[TD]New[/TD]
[TD]Different
[/TD]
[TD]New
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Normal
[/TD]
[TD]Opposite[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Five[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[TD]Sixth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Help
[/TD]
[TD]Sign
[/TD]
[TD]Help[/TD]
[TD]Sign[/TD]
[TD]Street[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]Z
[/TD]
[TD="align: center"]AA
[/TD]
[TD="align: center"]AB
[/TD]
[TD="align: center"]AC
[/TD]
[/TR]
[TR]
[TD]Once
[/TD]
[TD]fine
[/TD]
[TD]Once
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD]Twice[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD]Same
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Different
[/TD]
[TD]New
[/TD]
[TD]Third[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Different
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Fourth
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Normal
[/TD]
[TD]Five[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth[/TD]
[TD]Opposite
[/TD]
[TD]Sixth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Help
[/TD]
[TD]Sign
[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Help
[/TD]
[TD]Street
[/TD]
[TD]Help[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]Z
[/TD]
[TD="align: center"]AA
[/TD]
[TD="align: center"]AB
[/TD]
[TD="align: center"]AC
[/TD]
[/TR]
[TR]
[TD]Once
[/TD]
[TD]fine
[/TD]
[TD]Once
[/TD]
[TD]fine
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Twice[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD]Same
[/TD]
[TD]Double
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Third[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Different[/TD]
[TD]New[/TD]
[TD]Different
[/TD]
[TD]New
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Fourth
[/TD]
[TD]Match
[/TD]
[TD]Normal
[/TD]
[TD]Opposite[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Five[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[TD]Sixth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Help
[/TD]
[TD]Sign
[/TD]
[TD]Help[/TD]
[TD]Sign[/TD]
[TD]Street[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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