A B C D E F G
1 22 1 3 5 7 9
2 33
3 22
4 44
5 55
6 66
7 22 2 4 6 8 10
8 22 5 10 15 20 25

I am desprately looking for a formula that will organize data by using a
common cell number, then taking the remainder of the data in that row and
only looking at those rows for comparing data. In the example above column A
w/ "22" openning the door for the data in rows 1, 7 and 8.

Thanks very much
Mike