IF THEN Replace Statement

Question

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:

if_then_replace_addresses.yxmd

philipmannering · Accepted Answer

Hey @vujennyfer

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