Forum Discussion
Solved
Does Excel have Count Distinct options
I know the ability to countdistinct numbers exists in Power Query and other tools but can it be done in Excel? I only work in excel and have not had good luck learning Power Query. I am just an old ...
=SUM(1/COUNTIF(B5:B13,B5:B13))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
This one did not work for me but thank you for the reply!