Editing Find and remove duplicates (section)

== Find and remove duplicates in Google Spreadsheet ==

* [https://www.ablebits.com/google-sheets-add-ons/remove-duplicates/index.php Remove duplicates in Google Sheets] 30 days free {{access | date = 2019-02-26}}
* [https://chrome.google.com/webstore/detail/power-tools/dofhceeoedodcaheeoacmadcpegkjobi Power Tools] for Google Spreadsheet {{access | date = 2019-02-26}}
** Menu: Data -> Remove duplicates
* Google spreadsheet add-on: [https://www.ablebits.com/google-sheets-add-ons/remove-duplicates/howto.php Remove Duplicates for Google Sheets help]
* [https://sheetaki.com/remove-duplicates-from-comma-delimited-strings-in-google-sheets/ Remove Duplicates from Comma-Delimited Strings in Google Sheets - Sheetaki]

Initial contents of cell A2 which its separator is comma or whitespace. The second parameter of SPLIT function is {{kbd | key=<nowiki>", "</nowiki>}} (a comma followed by a space):
<pre>
apple, banana, apple
</pre>

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>
If cell A2's content is separated by a comma or whitespace:
= JOIN(", ",UNIQUE(TRANSPOSE(SPLIT(A2,", "))))

If cell A2's content is separated solely by a comma:
= JOIN(", ", UNIQUE(TRANSPOSE(ARRAYFORMULA(TRIM(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>

Cell A2's contents after removing duplicates:
<pre>
apple, banana
</pre>