Ask Your Question

Force unigue value in column. - Calc

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

JoelH gravatar image

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

edit retag flag offensive close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 46 times

Last updated: Jun 09 '17