UNIQUE formula + IF

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 CSweden ActiveSweden ActiveSpain InactiveDenmark InactiveEngland ActiveEngland Active

Preferred outcome

SwedenEngland
4

Best Answer

try:

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

0

Use

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

enter image description here

Try

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

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

Random Posts

React js Compiled with warningsWhat is the right way to insert an equation within a pseudo codeNot able to login/signup in appwrite consoleWhat is the difference between gravity and layout_gravity in Android?How can I differentiate a 0 from false in a map? [duplicate]Excel VBA: If cell contains certain text then input range of cells with that contentPython namedlist FACTORY default with valuesWhat does mongo's db.stats().ok means?javascript websocket onmessage event.datarackup: command not founderror: expected unqualified-id before 'void'pyspark ml model map id column after predictionWhere to place requirements.yml for Ansible and use it to resolve dependencies?How to add the legend for hline in ggplot2How to make a function wait until a callback has been called using node.jsjQuery: How can I show an image popup onclick of the thumbnail?Using ifelse Within applyHow do you call a function in a react-table accessor? (reactjs)Force "git push" to overwrite remote filesHow to subscribe to all topics/messages using NodeJS mqtt, emqx