Excel tutorials

Here we are going to use Excels in-built function UNIQUE to count the number of times a specific car appears in a list.

Now we need to find all the UNIQUE values in this list.

In cell C2 – enter the following formula:

=UNIQUE(A2:A11)

Now we are ready to use another built-in function, the COUNTIF, to count the number of times each car appears in the list in column A.

In cell D2 – enter the following formula:

=COUNTIF($A$2:$A$11;C2)

Drag the formula down to cell D6.