Forum Discussion

AngieBowes's avatar
AngieBowes
Copper Contributor
Jun 21, 2023

Excel function countif

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)

excel
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jun 21, 2023

    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.

     

Resources