Imagine a spreadsheet with the data in the columns being the same as in the rows.
A B C D E
A 1 2 3 4 5
B 2 4 6 8 10
C 3 6 9 12 15
D 4 8 12 16 20
E 5 10 15 20 25
The above is a simple multiplication "table" to illustrate. The alphabets are my column and row headers.
In the "table" above 1 x 2 = 2 x 1, 2 x 3 = 3 x 2... etc.
If I implement a reverse lookup and search for 12 as an example, I'd get Column D and Row C. I'd also get Column C, Row D.
These two results are essentially the same result only the row and column have been reversed as it were. CD vs DC (If I were just returning names).
How do I then go about trimming the result that I get to only one of the options above?
Here is a link to the file I'm working on. Most of what I wanted to do has already been figured out, I just need help with this one last thing.
Thanks in advance.
A B C D E
A 1 2 3 4 5
B 2 4 6 8 10
C 3 6 9 12 15
D 4 8 12 16 20
E 5 10 15 20 25
The above is a simple multiplication "table" to illustrate. The alphabets are my column and row headers.
In the "table" above 1 x 2 = 2 x 1, 2 x 3 = 3 x 2... etc.
If I implement a reverse lookup and search for 12 as an example, I'd get Column D and Row C. I'd also get Column C, Row D.
These two results are essentially the same result only the row and column have been reversed as it were. CD vs DC (If I were just returning names).
How do I then go about trimming the result that I get to only one of the options above?
Here is a link to the file I'm working on. Most of what I wanted to do has already been figured out, I just need help with this one last thing.
Thanks in advance.