I am trying to make a report for my job. We have different HR systems submitting files to us and we want to know the frequency of each systems submits. I have attached the excel spreadsheet so far which includes the list of the dates they have submitted since September. How would I go about doing this for this system and others?
My take on this is that there doesn't seem to be a discernible pattern. Enter this formula in E5 and fill down through E20:
=B6-B5
Enter this formula in E21:
=AVERAGE(E5:E20)
It looks to me like it's roughly every four days or so...
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Number of reports since September:
=COUNTIF($B$5:$B$21, ">10/1/2012")
What do you mean by frequency? Do you want something like avg. number of days between reports?
edit: sorry hadn't refreshed. tlafferty pretty much nailed it...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks