Count Unique Values

Cesar Perez
✭✭✭✭
Hi there, hope someone can help me with the following request. I have a sheet to track delinquent items. An item can be entered in the sheet multiples times for each day it is delinquent. I need to create a rollup sheet that will summarize the data as follows: First by item, then by year, then by month, and then by name. The counts should be done until the item is cleared. The image below shows the columns in the file.
Answers
-
Try looking at the reports function with Grouping enabled.
- Group by Item Code
- Count the number of unique "Date"
- Filter only for items marked as "Delinquent"
- You can also group/Count on Year and month but it might get a bit busy
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives