Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2020, 11:53 AM
p45cal's Avatar
p45cal p45cal is offline Generate daily report from different columns Windows 10 Generate daily report from different columns Office 2019
Expert
 
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

re:"2. The total number of BOOKS per day. No matter if Claire appears twice, it should be counted as two."
Can Claire appear twice in a single day with the same book, and would it count as two books?
Perhaps you meant "2. The total number of BOOKS per day. No matter if the same book appears twice, it should be counted as two."?


Anyway, is this picture showing the right results for the data in your attachment?:
Box


(can't attach a picture directly here)
Reply With Quote
  #2  
Old 04-02-2020, 05:07 AM
dita dita is offline Generate daily report from different columns Windows XP Generate daily report from different columns Office 2010 64bit
Advanced Beginner
Generate daily report from different columns
 
Join Date: Apr 2018
Posts: 34
dita is on a distinguished road
Default

Hello p45cal,


Yes sorry, you´re absolutely right.


I meant to say "2. The total number of BOOKS per day. No matter if the same book appears twice, it should be counted as two."


Hope this is clear to you now.


Many thanks!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Generate custom report based on user selection? zephyrus17 Excel 4 05-28-2024 05:55 AM
Daily incoming email count report Outlookmess Outlook 1 03-30-2019 02:30 AM
How to count unique names appeared on specific date for daily report? specky_ Excel 5 02-19-2019 02:26 AM
Generate daily report from different columns Novice to Pivot Table: Need help to generate a report in a predefined format Himansu Excel 2 10-26-2014 03:57 PM
Creating Daily report forms DaveServo Excel 4 05-20-2011 03:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:06 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