I am hoping to get help with this equation I have been researching unsuccessfully for a while now.

What I have is:

Column A:The name of a company we did a "job" for.

Column F:Job number of each job recieved.

what I would like to do is make an equation that will Count the number of times a certain company is listed in column A, but I only want to count it once if the associated job number is listed two or more times in column F.

For example:

Say we did a job for "target". the specific job number is 2108. I only want to count the word "target" once if in column F, 2108 is listed two or three times.

We do multiple jobs for the same companies. So on a given day, we may have recorded that we did multiple different jobs for "target". This would result in different job numbers in column F, and multiple listings of "target in column A. But say in that given day we started a job for "target", stopped that job to work on something else, and then revisited the job later in the day. Since we record the exact times spent on each job throughout the day, the job we revisited would list "target" two times in column A, and list the corresponding job number two times in column F.

It may look somethings like this:

Target 8:00am-9:15 2108

Walmart 9:30 - 10:15 2459

Target 10:30- 10:45 2119

Macys 11:00- 12:00 2309

Target 1:00-3:00 2108

and so on....

Notice that target is listed 3 different times in what would be column A. However, In what would be column F, there are only 2 different job numbers listed, but one of them is listed twice (2108,2119,2108). What I want is my equation to list that we worked on two jobs for target, instead of 3.

Much appreciated,

thanks