IF THEN Replace Statement

[vujennyfer]

Hello, 

I am trying to use the IF THEN statement to count the max addresses for a given name and then replace all the addresses with the most populated one. To goal is to have one address per name. 

IF [_current_name_]

THEN count(max(address_1)) AND

REPLACE(address_1, city, state, zip) with max(address_1, city, state, zip)

before: 

after: 

[PhilipMannering · Accepted solution]

Hey @vujennyfer 

You won't be able to do this in the Formula Tool. Your best bet is something like this,

[vujennyfer]

This worked perfectly!! Thank you @PhilipMannering 🙂