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!!!