'Returning each text element just once from a selected range of cells
I'm making a google sheet file to track some of my expenses. I need to return an array starting from a column, that takes each text element from another column just once. For example, i want to take each element from column A and return an array starting from C1 that takes all elements from A just once. What's the formula for doing this?
Solution 1:[1]
use this formula:
=UNIQUE(A1:A)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |