UNIQUE formula + IF

Question

Looking to combine google sheet unique formula with an If formula. See below. The outcome should be Unique values from column "B" and only active values from column "C".

Column B.      Column C
Sweden         Active
Sweden         Active
Spain          Inactive
Denmark        Inactive
England        Active
England        Active

Preferred outcome

Sweden
England

score 3 · Answer 1 · answered Dec 20 '19 at 20:08

3

try:

=UNIQUE(QUERY(B:C, "select B where C = 'Active'", 0))

answered Dec 20 '19 at 20:08

player0

124,011
12
67
124

score 2 · Answer 2 · answered Dec 20 '19 at 19:12

2

Use

=UNIQUE(FILTER(B:B,C:C="Active"))

answered Dec 20 '19 at 19:12

Scott Craner

148,073
10
49
81

@bertathaman please consider marking as correct by clicking the check mark by the answer. – Scott Craner Dec 20 '19 at 19:29

score 1 · Answer 3 · answered Dec 23 '19 at 09:12

1

Try

=QUERY(UNIQUE(D16:E21),"Select Col1 where Col2='Active'")

answered Dec 23 '19 at 09:12

user11982798

1,878
1
6
8

2

*Try* is not an answer. You must be sure in your answer. *Try* should be in comments. – Aksen P Dec 23 '19 at 13:57
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - [From Review](/review/low-quality-posts/24925107) – Aksen P Dec 23 '19 at 13:57
Althought this give the result as hope but different row, I accept your review. Thanks – user11982798 Dec 23 '19 at 15:07

score 0 · Answer 4 · answered Sep 26 '22 at 15:07

0

Use filter. Sample Usage:

FILTER(A2:B26, A2:A26 > 5, D2:D26 < 10)

FILTER(A2:C5, {TRUE; TRUE; FALSE; TRUE})

FILTER(A2:B10, NOT(ISBLANK(A2:A10)))

https://support.google.com/docs/answer/3093197?hl=en

answered Sep 26 '22 at 15:07

Lucas B.

489
5
15

UNIQUE formula + IF

4 Answers4