Hi all,
In its simplest form, i am trying to create a formula which will automatically count the number of unique references in Column A for a category in column B.
In the basic example below the solution would be that their are 4 unique references labelled under Apple and 2 unique references for bananas.
Your help in this matter is greatly appreciated.
Many thanks
Tenal
Note that the references and category values are text based.
<tbody>
</tbody>
In its simplest form, i am trying to create a formula which will automatically count the number of unique references in Column A for a category in column B.
In the basic example below the solution would be that their are 4 unique references labelled under Apple and 2 unique references for bananas.
Your help in this matter is greatly appreciated.
Many thanks
Tenal
Note that the references and category values are text based.
Reference | Category |
CR1 | Apple |
CR2 | Apple |
CR3 | Apple |
CR1 | Apple |
CR4 | Apple |
CR1 | Banana |
CR1 | Banana |
CR2 | Banana |
CR2 | Banana |
<tbody>
</tbody>