Any formula, if duplicate, say: "Duplicate"?
Any formula, if there's a duplicate in this column, say: "Duplicate"?
Thank you!
Best Answers
-
Try something like this...
=IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) > 1, "Duplicate")
-
Ok. Put it in any column OTHER than that column.
You cannot put the formula in the column that you are referencing.
Answers
-
Try something like this...
=IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) > 1, "Duplicate")
-
-
=COUNTIF([Check Duplicates]:[Check Duplicates], [Check Duplicates]@row)
If the count function returns a value greater than 1 there is a duplicate.
-
I actualy have now "#CIRCULAR REFERENCE"
What are the column names?
i want to see if "column 1" has duplicate, what's my formula?
Thank you!
-
You would need to put the formula into a different column and reference the column that you are wanting to evaluate.
-
would this be good?
it syays blocked..
=COUNTIF([All Names]:[All Names], >1, "Duplicate")
Thank you!
-
=IF(COUNTIFS([All Names]:[All Names], [All Names]@row) > 1, "Duplicate")
Put this in any text/number column other than the [All Names] column and it should work.
-
-
What column are you putting the formula in?
-
In the all names column
-
Ok. Put it in any column OTHER than that column.
You cannot put the formula in the column that you are referencing.
-
-
I didn't do it correctly.
Now it's perfect.
Thank you!!
Is there a way it should say, duplicate, but only when column b has a value?
-
Try this...
=IF(AND([Column B]@row <> "", COUNTIFS([All Names]:[All Names], [All Names]@row) > 1), "Duplicate"))
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!