Finding percentages

[sed]

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.]

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