Forum Discussion

DianaT's avatar
DianaT
Copper Contributor
Jan 14, 2020
Solved

How to remove duplicates across one row?

Hello all.   I have an spreadsheet that looks similar to the below. I'm trying to build a formula for the last column, which counts the number of different names across each row but only counting d...
excel
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 14, 2020

Hi DianaT 

 

Please see attached file which contains the function you are looking for in column G. Hope this helps

  • DianaT's avatar
    DianaT
    Copper Contributor
    Jan 14, 2020

    Thank you so much PascalKTeam. Works like a charm.

    • PascalKTeam's avatar
      PascalKTeam
      Iron Contributor
      Jan 14, 2020
      Great! Happy to hear that!

      Please mark this answer as the solutions