Duplicate data entry

# Hi Everyone,

I badly need help.

I want to make sure that no duplicate data entry occurs

The fields in each row are as follows: (State, City, House Number)

Example

State City House Number Duplicate (y/n)
Dhofar Salalah 234 N
Dhofar Hafa 234 N
Dakhiliyah Salalah 234 N
Dhofar Salalah 234 Y ( Duplicate)
0 3 207
3 REPLIES 3

JuneCorpuz
Participant V

Hello!

Please check the article below.

Valid If is commonly used to prevent duplicate values from occurring within a table. For instance, to ensure the current column value is the only occurrence in the entire Customer Name column of the Customers table:

ISBLANK(
  FILTER(
    "Customers",
    ([_THIS] = [Customer Name])
  )
  - LIST([_THISROW])
)

Source:

Hello Junr

Iโ€™m couldnโ€™t understand what to do

Could you help me with code for my problem

Steve
Participant V
Top Labels in this Space