Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.

Sign up to join this community

Anybody can ask a question

Anybody can answer

The best answers are voted up and rise to the top

Validate that a combination of cells are unique in a row in Google Sheets

Asked 2 months ago

Active 1 month ago

Viewed 5 times

0

I'm looking accomplish the following but in a Google sheet.

https://superuser.com/questions/902400/validate-that-a-combination-of-cells-are-unique-in-a-row-in-excel

I have a column of first names and a column of last names. I want to validate that the combination of these two cells in each row is unique.

edited Jun 5 at 9:05

user0

1

asked Jun 5 at 5:48

thanrl

1

add a comment |

1 Answer 1

active oldest votes

0

use function called UNIQUE:
```
=UNIQUE(A1:B)
```

answered Jun 5 at 9:04

user0

1

add a comment |

Your Answer

Sign up or log in

Post as a guest

Name

Email

Required, but never shown

Post as a guest

Name

Email

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged google-sheets formulas or ask your own question.

Web Applications Stack Exchange works best with JavaScript enabled