I have been trying to find all duplicates within a string of letters, but I do not know where to start.

I had stretched out of all of the letters into separate tiles thinking that I would be able to use to compare tiles with If Then statements.

I tried to manually compare each letter with if(b1=b2,"Ignore",b1). This could work, but I would have to type out the grid coordinates to compare all 81 combinations for the string.

CodePudding user response：

To remove duplicates from a string of letters in Google Sheets, you can use the UNIQUE function. This function takes a range of cells as its input and returns a list of unique values in that range.

Here is an example of how you can use the UNIQUE function to remove duplicates from a string of letters:

1. Enter the string of letters into a single cell in Google Sheets, for example, cell A1.
2. In a new cell, enter the UNIQUE function, for example, in cell B1, enter the following formula: =UNIQUE(A1). This will return a list of unique letters from the string in cell A1.
3. You can then use the JOIN function to combine the unique letters into a single string. For example, in cell C1, enter the following formula: =JOIN(",", B1). This will return the unique letters as a comma-separated string.

Alternatively, you can also use the FILTER function to remove duplicates from a string of letters. Here is an example of how you can use the FILTER function to do this:

1. Enter the string of letters into a single cell in Google Sheets, for example, cell A1.
2. In a new cell, enter the FILTER function, for example, in cell B1, enter the following formula: =FILTER(A1, A1 <> ""). This will return a list of letters from the string in cell A1, excluding any empty values.
3. You can then use the UNIQUE function to remove duplicates from the list of letters. For example, in cell C1, enter the following formula: =UNIQUE(B1). This will return a list of unique letters from the string in cell A1.
4. You can then use the JOIN function to combine the unique letters into a single string. For example, in cell D1, enter the following formula: =JOIN(",", C1). This will return the unique letters as a comma-separated string.

I hope this helps!