254 shaares
7 results
tagged
excel
A little while ago I received an email from Deborah asking what formula she can use to list missing numbers from a range.
I’ve seen loads of different approaches to this over the years but today I’m going to share with you the formula I think is the most elegant.
I’ve seen loads of different approaches to this over the years but today I’m going to share with you the formula I think is the most elegant.
If you have the need to highlight cells with duplicate or unique values in Microsoft Excel 2016 or 2013, here’s an easy way to do it.
Whether you obtain data from an external source or have someone performing data entry, mistakes can happen. If you’re concerned that you may have duplicate data in Microsoft Excel, you can find out quickly with conditional formatting.
Before you spend money on special fonts or software, you should take a look at one of the best hidden native features of Microsoft Office—creating and printing barcodes. You can print several different kinds of codes from within Word. 1D codes like CODE128, CODE39, UPC A and UPC E, and EAN are available, and the big daddy of 2D barcodes, the QR code, is also included. This guide will show you exactly how to take advantage of these features.
In this example mail merge is being used to format a merge field in red if the value is greater than 20, and if not; format the merge field in black.
