Hello:
This is referencing Excel 2007.

I am using a formula to be able to identify if a particular ID is "Approved
1st time". Where it gets tricky is that the data needs to be analyzed at the
ID level and sometimes there are multiple lines referencing the same ID.

In the example below, ALL lines that reference the same ID would need to
meet the criteria in order to be considered "approved 1st time".
Criteria for approved 1st time is as follows:
- Date field must be blank - AND-
- Eval status contains *Approved*

Based on above criteria, only ID#PL0698 would qualify. But I only want it to
count as 1, not 2 in the total analysis of "approved 1st time".

In addition, I need a total count of how many discrete IDs there are so that
I can show the percentage that were approved 1st time. In this example, 1 of
2 or 50% Approved 1st time.

Category ID# Date Eval Status
Size PL062 Rejected by HQ
Quality PL062 Approved by HQ
Design PL062 Approved by BP
Size PL0698 Approved by HQ
Design PL0698 Approved by HQ

Thank you!