Find and remove duplicates: Difference between revisions
Jump to navigation
Jump to search
→Find and remove duplicates in Google Spreadsheet
| Line 132: | Line 132: | ||
</pre> | </pre> | ||
To remove duplicates from Cell A2, use the following formula: | To remove duplicates from Cell A2, use the following formula: ((learn more about the UNIQUE function from Google Help<ref>[https://support.google.com/docs/answer/10522653?hl=zh-Hant UNIQUE 函式 - Google 文件編輯器說明]</ref> or Microsoft support<ref>[https://support.microsoft.com/zh-tw/office/unique-%E5%87%BD%E6%95%B8-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e UNIQUE 函數 - Microsoft 支援服務]</ref>) | ||
<pre> | <pre> | ||
=JOIN(", ",UNIQUE(TRANSPOSE(SPLIT(A2,", ")))) | = JOIN(", ",UNIQUE(TRANSPOSE(SPLIT(A2,", ")))) | ||
</pre> | |||
Alternatively, activate the `by_column=true` parameter in the second argument of the UNIQUE function: | |||
<pre> | |||
= JOIN(", ",UNIQUE(SPLIT(A2,", "), 1))) | |||
</pre> | </pre> | ||