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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!