Find and remove duplicates: Difference between revisions
Jump to navigation
Jump to search
→Find and remove duplicates in Google Spreadsheet
| Line 125: | Line 125: | ||
** Menu: Data -> Remove duplicates | ** 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] | * 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 {{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: | |||
<pre> | |||
=JOIN(", ",UNIQUE(TRANSPOSE(SPLIT(A2,", ")))) | |||
</pre> | |||
Cell A2's contents after removing duplicates: | |||
<pre> | |||
apple, banana | |||
</pre> | |||
== Find and remove duplicates in PHP == | == Find and remove duplicates in PHP == | ||