You can then delete the unique values from the spreadsheet or simply copy the duplicate values to a new spreadsheet to separate them from the non-duplicate values.

I usually set up my annual budget in one Excel workbook, and then I add 12 more sheets—one for each month of the year—so I can easily track the monthly data. Each sheet contains the same rows, columns ...