Ask Your Question

Force unique value in column. - Calc [closed]

asked 2017-06-09 10:41:05 +0200

JoelH gravatar image

updated 2020-10-06 14:10:37 +0200

Alex Kemp gravatar image

Hi How can i lock a column in calc so that i can only write unique values?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-06 14:10:30.530899

1 Answer

Sort by » oldest newest most voted

answered 2017-06-09 11:17:01 +0200

There's no such option in Calc. You may use formulas to easily identify when entered value already exists above (using another column, or conditional formatting), but not prevent the entry. There's a Validity tool, but AFAIK there's no way to use it to validate that there's no such value in a range.

You may want to use Base for that possibly? That's actually database feature.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-06-09 10:41:05 +0200

Seen: 130 times

Last updated: Oct 06 '20