=1/SUMPRODUCT(--($A$2:$A$13=A2),--($B$2:$B$13=B2))
should total to 1 for the same name and same status
adding a field with this equation should give you the number
Are you really interested as to how many first interviews each candidate had?

"BW.Wooster" wrote:

Thank you for your reply,

Within the original data there is a column with the 'status' data
(such as 1st, 2nd, 3rd interview etc) and another column with the last
name data in. The original data is exported from a database and is not
grouped in any way. The difficulty is that people in my company attach
the status of 1st, 2nd, 3rd, etc interview to the people in the
database more than once for each job (the data for different jobs is
exported into separate sheets, each with their own pivot table). I
only want to count each type of status once for each individual.

Below is an example of the original data from which the pivot table is
prepared:


Name Status Job
Smith First Interview Head of Informatics
Jones Second Interview Head of Informatics
Withers First Interview Head of Informatics
Jones First Interview Head of Informatics
Withers Second Interview Head of Informatics
Smith First Interview Head of Informatics
Smith First Interview Head of Informatics
Withers Second Interview Head of Informatics
Jones First Interview Head of Informatics
Jones Second Interview Head of Informatics
Smith First Interview Head of Informatics
Withers Second Interview Head of Informatics

I have tried your suggestion of grouping the data and using the
formula on each type of 'status' but that does not seem to give me the
same answers as doing a manual count of the original table.

Does this answer your question? and thank you for your help,