Thread: Counting Occurance using Pivot Table
View Single Post
 
Old 08-15-2016, 05:26 PM
Mandy11 Mandy11 is offline Windows 7 64bit Office 2003
Novice
  
Join Date: May 2015
Posts: 18
Mandy11 is on a distinguished road
Default
A few steps:

1)Sort the spreadsheet by Name
2)Insert a column and write an IF formula, see attached spreadsheet.
3)If you see ??????????? then there is a duplicate (NOTE: the 1st duplicate does not have the ?????????)
Attached Files
File Type: xlsx Book1.xlsx (8.7 KB, 8 views)
Reply With Quote