Do you want to count distinct values in a list in Excel? When performing any data analysis in Excel you will often...
About the Author
John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.
Articles from John MacDougall
Do you want to remove the formatting from your Excel table? Tables have a lot of great features and are perfect for...
Do you need to extend your Excel table? Tables are a great tool for storing all your tabular data, but when you want...