Smartsheet formulas to get unique values

code.bas

Use case on say 6 columns having email addresses, and you want to get only the unique values.
  
  Copy-paste the formulas in column pairs [iterate, scrubbedapp]

iterate2 column formula:
=SUBSTITUTE([iterate1]2, "#" + [ScrubbedApp1]2, "")

ScrubbedApp2 column formula:
=IF(NOT(ISBLANK([iterate2]1)), 
    MID([iterate2]1, 2, 
      IF(FIND("#", [iterate2]1, 2) > 0, 
          FIND("#", [iterate2]1, 2) - 2, 
          LEN([iterate2]1))), "")