Ask Your Question

force column unique [closed]

asked 2013-11-14 15:56:39 +0200

Lope gravatar image

I want to set a rule for a column to force it to have unique values only.

That way if I fill in Bob John Fred Bob

It throws an error when I fill in the second bob.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 15:12:08.840485


Pretty much the same question I am trying to find an answer to. I am using Calc; I have a column of serial numbers; I want to make sure that I don't mis-type something and enter two of the same number. How do I force the spreadsheet to disallow or warn me when I key in a value that is already present

JLGranec gravatar imageJLGranec ( 2015-05-19 23:08:19 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-11-14 23:05:08 +0200

m.a.riosv gravatar image

Please, what are you talking about: Base, Writer, Calc? Try explaining with bit of detail the question.

edit flag offensive delete link more

Question Tools



Asked: 2013-11-14 15:56:39 +0200

Seen: 214 times

Last updated: Nov 14 '13