Do you want to count the number of unique values in your Excel data? Knowing the number of unique items in a column...
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 need to group similar items in Excel? Excel has a lot of ways to group items that are the same, but these rely...
Do you need to get gold prices into your Excel workbook? Understanding the gold commodity market requires constant...