英文:
EXCEL: Unique fields but exclude if it contains the word 'Total'
问题
以下是已经翻译好的部分：
UNIQUE(FILTER(A1:B6,A1<>"*Total*"))
表格：
| Id | name |
|---|---|
| A | A |
| A | A |
| A Total | A |
| B | B |
| B Total | B |
结果：
| Id | name |
|---|---|
| A | A |
| B | B |
英文:
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 |
答案1
得分: 3
尝试：
=UNIQUE(FILTER(A1:B6,NOT(ISNUMBER(SEARCH("Total",A1:A6)))))
结果：
英文:
Try
=UNIQUE(FILTER(A1:B6,NOT(ISNUMBER(SEARCH("Total",A1:A6)))))
Result:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论