Forum Discussion
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 un...
=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.