CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaspreadsheet
zongshita
zongshita

Reputation: 191

Find Unique Values in two data based on Date

I am trying to find two unique names in two data based on Date. Could you kindly advise what formula can be used? Thank you so much

https://docs.google.com/spreadsheets/d/1HKnESOUKjh4cfVFCLwQkET3Z0F7LCE5X3F9492IKwCI/edit?usp=sharing

enter image description here

Upvotes: 0

Views: 184

Answers (1)

JPV
JPV

Reputation: 27282

In cell H12 I entered

=query(query({A2:B; D3:E}, "Select Col1, Col2, count(Col2) where Col2 <>'' group by Col1, Col2", 1), "Select Col1, Col2 where Col3 = 1",1)

See if that works for you?

Upvotes: 1

Related Questions