Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-15-2016, 05:26 PM
Mandy11 Mandy11 is offline Counting Occurance using Pivot Table Windows 7 64bit Counting Occurance using Pivot Table 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Occurance using Pivot Table Counting table rows in a page RavenSuzumiya Word Tables 1 06-09-2016 03:38 PM
Counting Occurance using Pivot Table Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook JaxV Excel 9 11-14-2014 12:25 AM
Pivot Table Question- Can the table display in the order the boxes were checked/selected? blackjack Excel 0 09-13-2014 08:57 PM
Counting Occurance using Pivot Table Counting how many times a table or a field of a table is used in a document moose5267 Word Tables 1 08-15-2014 01:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft