# 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:
Hello Junr
Iโm couldnโt understand what to do
Could you help me with code for my problem
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |