Help with Filling the cells with same values

[hulkbrutus]

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.

[Jean-Balteryx]

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

[mceleavey]

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

[Greg_Murray]

@hulkbrutus,

I am not sure I fully understand the requirements, but here are 2 solutions that get you the desired result.

Thanks,

Greg