Looking to complete the following formula which allows me to find unique fields within column but not include any that have the word ‘Total’ in it.
I have the following formula but doesn’t work
UNIQUE(FILTER(A1:B6,A1<>"*Total*"))
Table
| Id | name |
|---|---|
| A | A |
| A | A |
| A Total | A |
| B | B |
| B Total | B |
Result
| Id | name |
|---|---|
| A | A |
| B | B |
>Solution :
Try
=UNIQUE(FILTER(A1:B6,NOT(ISNUMBER(SEARCH("Total",A1:A6)))))
Result:
