3 Replies Latest reply on Mar 8, 2011 8:00 AM by philmodjunk

    Finding Duplicate Values without finding empty entries

    lbellino

      Title

      Finding Duplicate Values without finding empty entries

      Post

      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.