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:
Solved! Go to Solution.
Hey @vujennyfer
You won't be able to do this in the Formula Tool. Your best bet is something like this,
This worked perfectly!! Thank you @PhilipMannering 🙂