A | B |
0 | 22418 |
0 | 22418 |
0 | 22418 |
521410 | 0 |
521410 | 22418 |
Problem Statement : To fill up Col A with the values 521410 as the vales in Col B correspond to that values .
For example: whenever we get a value 521410 in col A it should automatically fill 22418 in Col B and vice versa.
Hi @hulkbrutus ,
You can do this using a Formula Tool with following formulas :
For A
IF [B] = 22418
THEN 521410
ELSE [A]
ENDIF
(assuming integer types for fields)
For B
IF [A] = 521410
THEN 22418
ELSE [B]
ENDIF
Cheers,
Jean-Baptiste
Hi @hulkbrutus ,
You may need to provide some more information here. Are you saying you want the max value of Column A where there is a match to column B? In your example there are two values of A that match B.
Will there be other values of A that match, rather than just 0 and 521410?
M
I am not sure I fully understand the requirements, but here are 2 solutions that get you the desired result.
Thanks,
Greg