Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Finding percentages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sed - 30 May 2008 16:09 GMT
Call ID    Database ID    Name    Timing    Percentage
737593    amcgucki    SAP_MFG    Ontime    #NAME?
738917    chouser    APS FP    Ontime    #NAME?
736507    chouser    APS FP    Late    #NAME?
738202    jkuiper    SAP_MFG BUSINESS PROCESS    Late    #NAME?
737200    jkuiper    SAP_MFG BUSINESS PROCESS    Late    #NAME?
737199    jkuiper    SAP_MFG BUSINESS PROCESS    Late    #NAME?
737197    jkuiper    SAP_MFG BUSINESS PROCESS    Late    #NAME?
====================================================
Ok so I need to find the individual percentage of how many call ID's were
"Ontime"... so if jkuiper had 4 lates then he would have 0%, chouser would
have 50% etc... there are many users and many call id's that will be updated
daily so formulas have to be able to adapt the additions of everyday...
If i filter to find 14 users I have to be able to see what each of their
individual percentages were...  PLEASE HELP!!!
Mike H. - 30 May 2008 18:03 GMT
Add a calculated column to the right of your table that has this formula:
DatabaseID & " " & Timing.  It would yield this result on the first line:
amcgucki Ontime

If you set your data up as a table (Excel 2007), this will be much easier as
the formula will auto-perpetuate itself as you add new data.  Not sure about
tables in previous version as I never used them in Excel 2003 or before.

Let's say that column is column M.  
Let's say that column J is the column that has the Database ID in it.

Then create a small table where you want to see the results and enter every
name in the Database ID column.  Let's say that is in column O.  Then in
Column P place this formula:

=COUNTIF($M$17:$M$65000,O17&" Ontime")/COUNTIF($J$17:$J$65000,O17)

Then just copy that down all the other names you entered in col o.  That is
all you need.  You'll have to adjust the 17's above if your data starts
higher up.  But that should do it.  HTH

> Call ID    Database ID    Name    Timing    Percentage
> 737593    amcgucki    SAP_MFG    Ontime    #NAME?
[quoted text clipped - 11 lines]
> If i filter to find 14 users I have to be able to see what each of their
> individual percentages were...  PLEASE HELP!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.