Duplicate values identification

I know the way to do it for a small table


But that cell reference all the cells in C1. It get to a huge number of reference quickly.

I've reached the 250 000 limit with that and around 4k rows.

Is there a different way that use less cell references ?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!