Unique entries code

Panorama X
4

I haven’t tested this, but I think changing the > to = would do the trick.

if linecount(lookupall("",info("fieldname"),«»,info("fieldname"),cr()))=1
    alertsheet "This is a unique value"
endif

Here is the link to the original no duplicates topic.