'Google Spreadsheet) How to leave unique row values by left n characters?

Using google spreadsheet, is there any way to leave unique values by left n characters?

For example, assume that I have a data set as below :

[AAA/123 AAA/345 BBB/123 CCC/123]

I want to just leave below 3 values filtered by first 3 characters (AAA/345 should be deleted)

[AAA/123 BBB/123 CCC/123]

functionuniquespreadsheet


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

How to write a function that only accepts one enum variant as input?

How to write a function that only accepts one enum variant as input?

How to write a function that only accepts one enum variant as input?

How to write a function that only accepts one enum variant as input?

Creating a multiplying function

Python syntax to return an expression only if its value is not None

Random word guessing game

Get std::set comparison as function parameter / complemet of a set without universal set

Dynamic function name in javascript?

Explanation of test case in the prisoner wall jump program

Can I name a JavaScript function and execute it immediately?

Expand eql clause of a defmethod statement to accept any function?

Swift function returning two different types

Laravel str_random() or custom function?

how to set the order or priority of functions call in jquery or javascript?