One of the most common questions I hear, is around how to manage duplicate values in Excel.
I’ve already covered off how to remove duplicate values in this post.
I personally feel the ability to remove and highlight duplicates should grouped together, but whilst removing duplicates forms part its own ‘feature’, highlighting duplicates forms part of the wider Conditional Formatting functionality.
Since Excel 2007, highlighting duplicates has been very straightforward, with a pre-defined option to enabling it. So it’s this approach I will cover in this post. It can still be achieved in 2003 using a simple formula, but hopefully by now everyone is using 2007+
Anyone who’s used Excel in earnest for any length of time – ie 2003 and earlier – probably remembers having to create a VBA add-in to tackle the removal of duplicate values – or sometimes a COUNTIF() function would suffice for smaller jobs.
I always used the superb ‘The Duplicate Master’ add-in
(Which can still be found here – though the availability of the link seems to come & go)
Whilst such add-ins still have a place, offering rich features, for basic day-to-day removal of duplicates, Excel now includes this functionality built-in – and has done since Office 2007.
Quite often, when writing queries, we want to load a table with a condition we want to pass to it (rather than hard-coding the value in the WHERE clause). Eg, load sales for a given year.
Ah yes, the obligatory link up to the upcoming Brazil 2014 World Cup – bet you didn’t expect to see one here, did you? Isn’t it nice when there’s a surprise at the end of the week? So, with no further ado, here is an Outlook holiday add-in to add the Brazil 2014 games relevant
You may get the impression from some of my posts, such as this one, that I like to be well connected, and ‘always on’. That’s true, to a point. I think these days, being able to access your corporate mail whenever & wherever is being seen as increasingly useful, and often a necessary part
When I set this site up in July 2013, I did so to have a place where I could ‘load’ things I’d learnt, found useful or got asked a lot, with others – both within the company I work for, and to those outside it who can also hopefully benefit from it. You may see