Forum Discussion
Tommy2355
Sep 15, 2022Copper Contributor
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 Vlookup guy and it does everything I need to do. I do have the need for countdistinct values in formulas but have not found it in Excel. Appreciate any help here.
Thaks
Tommy C
6 Replies
Sort By
- Harun24HRBronze Contributor
- Tommy2355Copper ContributorOutstanding! Thank you!
- DexterG_IIIIron Contributor
Tommy2355 The quick answer is yes, you can now get to that. A new formula called "unique" exists with office 365 and there's an option to restrict only to records which appear only once. If you're able to share your workbook I can help get you started with the formula.
- Tommy2355Copper ContributorI got the formula in the next post. Thank you for replying!
- OliverScheurichGold Contributor
=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.
- Tommy2355Copper ContributorThis one did not work for me but thank you for the reply!