Count number of unique items

[laxmikantpatil]

I have two tables as below

Name  Target

a            3

b            2  

c            1

d            2

Name Job Status

a           x      Complete

a           y     Incomplete

b          z       Incomplete

a          w      Incomplete

b          u       Complete

c          o        Complete

d          p        Incomplete

d          l         Complete

Now I want a new column in table to count number of completed jobs by a person and in the second column no. of incomplete jobs. (Just the count) So that I can see what percent of job is completed.

Please help.

Thank You

[shawne · Accepted solution]

@laxmikantpatil Try this: