Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem here. This is the table i got by using the following expression:
object_operator & ' -> ' & stuffs_operator | Cost |
---|---|
A -> A | 2 |
A -> B | 3 |
A -> C | 7 |
B -> A | 6 |
B -> B | 4 |
B -> C | 6 |
C -> A | 3 |
C -> B | 2 |
C -> C | 6 |
Is there any way to add "duplicated" data? For example, when there's A -> B and B -> A, the data will turn out to be A <-> B and will not display B -> A in the data anymore. Hence, adding up A -> B and B -> A together.
object_operator & ' -> ' & stuffs_operator | Cost |
---|---|
A <-> A | 3 |
A <-> B | 9 |
A <-> C | 10 |
B <-> B | 4 |
B <-> C | 8 |
C <-> C | 6 |
Can anyone tell me how am i suppose to do this WITHOUT TOUCHING ON SCRIPTS?
See attached example.
Thanks for the replied! I tried your codes but it only works for one field. I forgot to mention that actually for object_operator & ' ' & stuffs_operator, object_operator is one field and stuffs_operator is another field. What's another code for two fields instead of one field?
Thanks in advance!