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)

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:

2 Likes

Hello Junr

I’m couldn’t understand what to do

Could you help me with code for my problem