Finding Duplicate Values without finding empty entries
I would like to find duplicate number values, which if I use the ( ! ), it will shows all the duplicate values, including empty ones. Is there an operator/function that I can use to find duplicate number values without showing the empty ones? For example, I'm searching through square footage numbers and want to find other records that have the same square footage numbers. Thanks.