CODEWITHSUNDEEP
google-sheets
Owneds
Owneds

Reputation: 13

How to sort email addresses from google forms to one unique email?

Today I created a google form that saves automatic results to google sheets.

Image 1

The idea is that I send e-mail correspondence, but sometimes there are jokers who enter a different age, name, but the same e-mail. I would like to sort this from the results obtained into another sheet called "sort", people who are over 23 years of age.

I created the formula:

=UNIQUE(QUERY(ask!A:D;"Select * Where D>=23"))

And it working correct.

enter image description here

Now how to add options to the formula already created above, so that it shows only one email address so that they do not duplicate each other? (Regardless of the name or age column ...) I would like it to look like this in its final form:

enter image description here

Please help :)

Upvotes: 0

Views: 128

Answers (1)

player0
player0

Reputation: 1

perhaps try:

=UNIQUE(Ask!B2:C)

or try:

=SORTN(Ask!A2:D, 9^9, 2, 2, 0)

Upvotes: 2

Related Questions