I want to know when I add a duplicate a same value on a column. How can I do that?

sistecompanama74176

I have an Work Orde column. but usually maybe I repeat a value for make a task under a project line. I need a formula to identificate it and dont have duplicate rows with duplicate info.

sistecompanama74176

additional i need that the formula ignore the blank spaces, thanks

Genevieve P.

Hi @sistecompanama74176

It looks like you have been working on a formula in this thread, is that correct? https://community.smartsheet.com/discussion/40691/countif#latest

If so, this is the formula Paul helped create for you:

=IF(COUNTIFS([ID Number Column]:[ID Number Column], @cell = [ID Number Column]@row) > 1, 1)

If you wan to ignore any blank ID Number Columns, then you can add another statement at the beginning:

=IF([ID Number Column]@row = "", 0, IF(COUNTIFS([ID Number Column]:[ID Number Column], @cell = [ID Number Column]@row) > 1, 1))

This says that if the ID Number in that row is blank, to keep the box 0, or "unchecked". Then if it's not blank, it will read the rest of your formula. Let me know if this works for you!

Cheers,

Genevieve

sistecompanama74176

thanks works very good. Now i want to copy the formula for the entire column, I mean until 1 row to the final cell of the column, if possible?? and how can i do that ?? thanks again

Genevieve P.

Hi @sistecompanama74176

You can drag-fill the formula all the way down the column, see here: https://help.smartsheet.com/articles/2477471-dragfill

Or, you can click on row 1's cell, then go to the bottom of the sheet and shift + click the last cell. Then use the keyboard shortcut Ctrl + D (Windows) or Command + D (Mac).