Highlighting Duplicate Values in Excel – [Excel 2007, 2010, 2013]


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+ Read More

Format or Remove Borders from a Slicer or Timeline in Excel

Changing the formatting, or removing completely, the borders from Excel Slicers and Timelines isn’t obvious – read on to find out how Read More

Removing Duplicate Rows / Find Unique Values in Excel

[Excel 2007, 2010, 2013]

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.

It’s this built-in functionality that we’ll cover in this post. Read More

Creating a Clustered Stacked Chart in Excel – Excel 2013

Learn how to create a combined Stacked, Clustered Chart in Excel. One of the trickier charts to get to create in Excel – but is certainly possible. Read More

Concatenating Strings in Teradata – And What to Watch Out for with Fixed Length Fields

Concatenating Strings in Teradata is fairly straightforward, but there are a few things you need to watch out for. Read More

Populate a table by looping through items in a list / another table


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.

This can be easily achieved by creating a Macro, and passing a value to it… Read More

Adding shortcuts to your Teradata SQL Assistant Query Tabs

Move between tabs in Teradata’s SQL Assistant by assigning Short-Cuts to them Read More

World Cup Games in your Outlook Calendar

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 Read More

Alternatives to Outlook for your Personal Mail

  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 Read More

Site Updates – May 2014 – Visitor Stats and New Domain Registration

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 Read More

1 3 4 5 6 7 9