Help with Conditional Formula for a new column

[Yeonsujen]

Hello,

I have the following table:

ID Number

12345678

12345678x

55555555

55555555a

55555555b

I need the following output:

ID Number	Comment
12345678
12345678x	Duplicate
55555555
55555555a	Duplicate
55555555b	Duplicate

All ID Number's have a "00000000" format (8 digits) and if there are any letters after this then the new column Comment should say "Duplicate". Is there a way to do this using the formula tool?

[atcodedog05 · Accepted solution]

Hi @Yeonsujen 

Here is how you can do it.

Workflow:

Hope this helps : )

[Yeonsujen]

Hi @atcodedog05,

This works perfectly! Thank you so much for your quick response 😀

[Yeonsujen]

Hi @atcodedog05, I'm so sorry but I forgot to include this in my example above!

With your workflow, it works great if it's for duplicate ID Numbers but I need it more specifically for the ID Numbers with any letter afterwards. Please see the updated example below!

I have the following table:

ID Number
12345678
12345678
12345678
12345678x
55555555a
55555555
55555555
55555555b

I need the following output:

ID Number	Comment
12345678
12345678
12345678
12345678x	Duplicate
55555555a	Duplicate
55555555
55555555
55555555b	Duplicate

Sorry for the error on my side! Please let me know if you're able to help, otherwise I'm happy to repost again with the more accurate example!

[atcodedog05]

Happy to help : ) @Yeonsujen 

Cheers and have a nice day!

[atcodedog05 · Accepted solution]

Hi @Yeonsujen 

Please find the updated solution

Workflow:

Hope this helps : )

[Yeonsujen]

@atcodedog05 You're the best!!! Thank you so much for your help (again!). Have a lovely day also 😁