Buggy duplication search in table

Somehow, my “go-to” duplication filter has given me many false positive results.

Anyone seen this before?


tried using lookup too but clearly coda thinks these “entry data” are the same.

So I figured out a problem, I used a button to copy a certain column to the table, the button formula is recognising the “mywallets-matic” is a numbers column, but it is certainly seceted as text in the table.

The are the only columns that (after copying to the new table), has been returning the wrong data
Screenshot 2024-05-03 010329