Find duplicates

Corporate Corporate

Corporate Corporate ✭✭✭✭

04/24/25 in Formulas and Functions

Is there a logical expression to simply find duplicate numbers in a range of cells?

0 ·

Answers

markkrebs Community Champion

04/24/25

=COUNTIF([Column A]:[Column A], [Column A]@row

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Checking multiple sheets for duplicates
Hi, I have a workspace that is being used for uploading new information by a group of techs. This information is checked and then uploaded a database by another team. Currently, I have the sheet working to check duplicates within one sheet, but once the data is uploaded to the database the line is moved to another…
Can you create email notifications on several different cells in a single column
Good morning, My project team asked me to create an inventory smartsheet. They are requesting email notifications for a single column, but for different inventory amounts on each cell. Is this possible??
Using COUNTIFS with CONTAINS as a Criterion
I have a multi select list column in Sheet 1, containing campuses. In sheet two I am trying to get a count of how many times each campus is listed in the campus column in sheet 1. Here is my current formula: =COUNTIFS({Event Campus}, CONTAINS("Cypress", {Event Campus})) The results are always "0" for each campus. Given…