Hi All! Need help on my excel sheet.. I have an excel sheet contains list of projects.. where column A contains the job number, column B is the category, column C is the percentage of completion. Can somebody suggest a formula which will count the number of latest project proposals wherein it will only count the latest for a duplicate entry. (e.a. BI-10-01902). Tried using countifs but realize there were duplicate entries and cannot remove duplicate entries as I need for history purpsoses.

BI-10-01906 DBSP - Draft Review 22-Jan-14 20-Feb-14
BI-10-01901 DBSP - Draft Review 6-Feb-14 26-Feb-14
BI-10-01902 Project Proposal 60% eReview 24-Feb-14 16-Mar-14
BI-10-01904 Project Proposal 60% eReview 9-Mar-14 30-Mar-14
BI-10-01902 Project Proposal 90% eReview 9-Jan-14 30-May-14
BI-28-10014 Detail Design 60% eReview 29-Jan-14 25-Feb-14
BI-10-01902 Detail Design 60% eReview 27-Mar-14 16-Apr-14
BI-10-00886 DBSP - Approval 13-Apr-14 1-May-14
BI-10-01906 DBSP - Approval 22-Apr-14 13-May-14
BI-25-00010 Project Proposal 60% eReview 21-Apr-14 15-May-14
BI-10-01906 Project Proposal 60% eReview 27-Apr-14 8-May-14
BI-10-01257 Detail Design 90% eReview 28-Jan-14 24-Feb-14
BI-10-01427 Project Proposal 90% eReview 16-Apr-14 6-May-14
BI-10-01246 Project Proposal 30% eReview 15-Jan-14 13-Feb-14
BI-10-00996 DBSP - Approval 26-Dec-13 22-Jan-14
BI-10-01427 Detail Design 60% eReview 12-Mar-14 1-Apr-14
BI-10-00982 Detail Design 60% eReview 20-Jan-14 9-Feb-14
BI-10-01823 DBSP - Draft Review 11-May-14 29-May-14
BI-10-01823 DBSP - Approval 6-Feb-14 4-Mar-14
BI-10-01638 Project Proposal 90% eReview 4-Feb-14 25-Feb-14
BI-10-01824 DBSP - Draft Review 25-May-14 12-Jun-14
BI-10-01823 Project Proposal 60% eReview 25-May-14 12-Jun-14
BI-10-01467 Project Proposal 30% eReview 6-Feb-14 4-Mar-14