Sorry, wasn't sure how to do that! It's for when a document has a change, I need to be able to see how many documents that refer to it are affected. Here is my example table and expected output
:
[TABLE="width: 1002"]
<colgroup><col width="87" span="7" style="width: 65pt;"><col width="393" style="width: 295pt;"></colgroup><tbody>[TR]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ACB9CA]#ACB9CA[/URL] , align: center"]Document #[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ACB9CA]#ACB9CA[/URL] , align: center"]Reference 1[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ACB9CA]#ACB9CA[/URL] , align: center"]Reference 2[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ACB9CA]#ACB9CA[/URL] , align: center"]Reference 3[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ACB9CA]#ACB9CA[/URL] , align: center"]Reference 4[/TD]
[TD="class: xl67, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ACB9CA]#ACB9CA[/URL] , align: center"]Reference 5[/TD]
[TD="class: xl71, width: 87, align: center"] [/TD]
[TD="class: xl72, width: 393, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]1[/TD]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl66, align: center"]3[/TD]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl68, bgcolor: yellow, align: center"]Changed Document #[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl66, align: center"]7[/TD]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl66, align: center"]9[/TD]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl66, align: center"]1[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl70, align: center"]4[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]3[/TD]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl66, align: center"]7[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl73, align: center"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl66, align: center"]9[/TD]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl66, align: center"]1[/TD]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]Documents that contain references to changed document[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl66, align: center"]3[/TD]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl66, align: center"]7[/TD]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl66, align: center"]1[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl66, align: center"]9[/TD]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl66, align: center"]1[/TD]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl66, align: center"]3[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl66, align: center"]3[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]7[/TD]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl66, align: center"]9[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl66, align: center"]5[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl66, align: center"]1[/TD]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl66, align: center"]3[/TD]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl66, align: center"]7[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]9[/TD]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl66, align: center"]7[/TD]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl66, align: center"]8[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl66, align: center"]1[/TD]
[TD="class: xl66, align: center"]2[/TD]
[TD="class: xl66, align: center"]3[/TD]
[TD="class: xl66, align: center"]4[/TD]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl74, align: center"] [/TD]
[TD="class: xl66, align: center"]10[/TD]
[/TR]
</tbody>[/TABLE]