UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Count Days, Office 2013    
 
   
pwbrownapcom
post Jun 18 2019, 01:32 PM
Post#1



Posts: 9
Joined: 5-March 19



Good Afternoon all!
First, let me say thanks for any guidance, even if it is "this is not possible".

What we have is a spreadsheet that has every person listed for every day of the month/year/etc as they are data records. Have already put a "weekday" formula on the sheet so Sundays come across as "1", Mondays as "2", etc. But this happens for each record. So if there are 15 people on a sunday, if you "count" weekdays, it will return 15. What I am trying to do is count how many Sundays or "1's" but not duplicates.

I know how this must sound but appreciate any guidance or help that may be possible.

Thanks in advance!
Go to the top of the page
 
DanielPineault
post Jun 18 2019, 01:35 PM
Post#2


UtterAccess VIP
Posts: 6,717
Joined: 30-June 11



Any chance you can post a sample of the data and desired result.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th July 2019 - 02:53 AM