Excel function countif

[AngieBowes]

Hi,

I am trying to have a function that does the following:

When the values in column A are Axis 01 ( the axis can change so it will need to be able to change ), I want to know the number of uniques goals in column B ( the goals can be there twice, so I don't want to know how the total of cells, but the total of unique goals)

[#2]

@AngieBowes 

=SUM(N(IF($A$1:$A$21=E3,MATCH(IF($A$1:$A$21=E3,$B$1:$B$21),IF($A$1:$A$21=E3,$B$1:$B$21),0)=ROW($1:$21))))

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.