I have 293 pages of data, which tells me how long it took for 3748 requests for book loans to go from the requester (date 1) to being actioned by a staff member (1st action). Our measure of success for actioning a request is 5 days. I wish to work out the percentages for 0, 1, 2, 3, 4, 5 days and 5+ days.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with excel perentages based on data
- Thread starter Lhanster
- Start date
saltkev
Active Member
- Joined
- Oct 21, 2010
- Messages
- 324
- Office Version
- 2013
- Platform
- Windows
Hi
Your Problem seems pretty straight forward, so maybe I am missing a trick.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
Try using the "Countif" function to count the number of occasions the lend is actioned on the first day then the second day etc. Then total the each of the results. Use this total figure to divide into each of the sub totals to give percentage. If not understandable, send me a e-mail address and I will send you an example file.<o></o>
<o></o>
regards<o></o>
<o></o>
Saltkev <o></o>
Your Problem seems pretty straight forward, so maybe I am missing a trick.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o
></o>Try using the "Countif" function to count the number of occasions the lend is actioned on the first day then the second day etc. Then total the each of the results. Use this total figure to divide into each of the sub totals to give percentage. If not understandable, send me a e-mail address and I will send you an example file.<o
></o><o
></o>regards<o
></o><o
></o>Saltkev <o
></o>
Upvote
0
Similar threads
- Question
