Some people may complete multiple surveys for the PIT count, especially in communities where incentives such as gift cards are offered to participants. There are a few formulas in Microsoft Excel that, when used together, can make it easy to identify potential duplicates. The three step process for identifying potential duplicates shown below is as follows:
Potential matches will be marked as "TRUE" and can be highlighted by filtering for the data and changing the font to help the record stand out. After reviewing the records marked as TRUE, any that are actually duplicates can be archived by following these instructions.