Thinking wise I could even create a formula to show what row the number was
found.

ie.
Row Number
----- ---------
100 1
101 2
102 3
103 2
104 3
105 1

Having the results show:
1: 100, 105
2: 101, 103
3: 102, 104

Either have it be Column A has the 1, 2,3 and Column B has 100, 101, 102 and
Column C has 105, 103, 104.... or the 100, 105 can be in the same column if
possible.

Does anyone know the formula to make this?
Any help would be appreciated.