Hi, I want a way to do some analysis of a large data set , best way to explain is to show a little of the extract:

25.4 RPT_APPLICATION_D
25.4 RPT_APPLICATION_D
25.4 RPT_APPLICATION_D
25.5 RPT_ASSIGNED_AGENTS_D
25.5 RPT_ASSIGNED_AGENTS_D
25.6 RPT_CASH_ACCOUNT_D
25.6 RPT_CASH_ACCOUNT_D
25.6 RPT_CASH_ACCOUNT_D

Basically I want to be able to count the no of times in this example that 'RPT' appears in column B but ONLY when column A's Index no is unique i.e. I want the formula to return '3' rather than '8'