Thread: Generate daily report from different columns
View Single Post
 
Old 04-01-2020, 11:53 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
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