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
Happy to do so! But has the forum changed recently? I can only mark "best response" (which I did) but no "mark as solution" button....
PascalKTeam
Jan 15, 2020Iron Contributor
"best response" that's the one. Thank you very much