UNIQUEIF Excel Formula
I recently had an interesting question in a webinar. Could I create a formula like UNIQUEIF. I like a challenge so here is my answer.
(more…)Unique Entries in a Range in Excel
Sometimes the UNIQUE function won’t return what you’re expecting when you refer to a range of cells. You can use another function to allow you to extract the unique individual values from a range.
(more…)Excel Custom Function to Return Unique Random Whole Numbers
In last week’s blog post I covered a complex formula to return unique random whole numbers. In this weeks’ post we will look at how we can convert that complex formula into a custom function.
(more…)Unique Entries in Excel via a Conditional Format
Excel’s Conditional Formatting feature has a built-in unique option. Its unique option only identifies entries that are not repeated. This is different to the Advanced Filter Unique option which lists each unique item from a range once. To filter by entries only appearing once you can use Conditional Formatting with filtering. No formulas required. (more…)
Getting a unique list in Excel
I have blogged before about using the Advanced Filter technique to extract unique entries from a list. Well a PivotTable can do it too.