Forum Discussion
DianaT
Jan 15, 2020Copper Contributor
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...
- Jan 15, 2020
Hi DianaT
Please see attached file which contains the function you are looking for in column G. Hope this helps
DianaT
Jan 15, 2020Copper Contributor
Thank you so much PascalKTeam. Works like a charm.
PascalKTeam
Jan 15, 2020Iron Contributor
Great! Happy to hear that!
Please mark this answer as the solutions
Please mark this answer as the solutions