Unique filters in Excel – the manual ‘one-off’ options
There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel releases, old and new. Advanced Filter One is hiding at Data | Sort & Filter | Advanced […]
Unique() makes a once difficult task really easy in Excel
The new Unique() dynamic array function doesn’t let you do anything new in Excel, but it makes a once-complicated task into simplicity itself. Unique or distinct, no-duplicate lists, counting and sorting the results are all possible with easy formulas that won’t confuse. For as long as there’s been Excel, people have wanted to get ‘unique’ […]
Extend UNIQUE() for distinct values that appear more than once
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in a distinct list are possible with a simple extended formula. We’ve already shown the basics of Unique() either getting a list of Distinct values or values that only appear once aka Unique. But Unique() doesn’t […]
Have your say on Word’s new default font
Microsoft has decided that Calibri is getting a little tired, so it’s asking customers to vote on which font will replace it. Calibri has been the default font since Office 2007. It’s familiar to most people whether they realise it or not because it appears in many Word documents. The two fonts, Calibri (body text) […]
Office 2019 for Windows – all the facts, prices and warnings
Here’s all about Office 2019 for Windows – the facts, prices and shortcomings. There’s a matching page about Office 2019 for Mac. Before you get too excited Do NOT buy Office 2019 if you have Microsoft 365 like Microsoft 365 Family (formerly Home), Microsoft 365 Personal or an enterprise plan. In other words, you pay for […]
Office 2019 for Mac – all the facts, prices and warnings
All about Office 2019 for Mac the facts, prices and warnings. There’s a matching page about Office 2019 for Windows. Before you get too excited Do NOT buy Office 2019 if you have Microsoft 365 plan like Microsoft 365 Family (formerly Home), Microsoft 365 Personal or an enterprise plan. In other words, you pay for […]
Excel 365’s data sources now include dynamic arrays
Excel 365 for Windows is getting another option for importing data into PowerQuery, from a dynamic array. In many cases the original data source could be imported, sorted and filtered in many different ways. Importing a existing dynamic array is a useful extra trick for us Excel nerds. We can think of three uses right […]
Live Sorting & Filtering in Excel: How to Use FILTER() + SORT() for Dynamic Lists
Learn how to create live, dynamic sorted lists in Excel using the powerful combination of Sort()/SortBy() and Filter() functions. In Excel 365 and Office 2021+ dynamic array formulas like FILTER() let you extract a subset of data — and by wrapping that result inside SORT(), you can instantly sort the filtered list in whatever order […]
Office 2021 for Mac, your preview first look
Your first look at Office 2021 for Mac with Word, Excel, PowerPoint and Outlook, which is now out in public preview, showing off some of the new features. There’s only a Mac Office 2021 preview, no Office 2021 for Windows preview. Perhaps because there’s a few more innovations in a comparison of Office 2019 to […]
Office LTSC public preview now available
A public preview of the next perpetual licence Microsoft Office is now available. Called Office LTSC (Long Term Servicing Channel) it’s for volume customers only. Here are the options and how to get the preview. Office LTSC is the clumsily named non-subscription version of Office for organizations with volume licence agreement. See Office LTSC, first […]
Office LTSC, first look images
Here’s a first peek at Office LTSC for Word, Excel, PowerPoint, Outlook, Access, Publisher and OneNote which is now out in public preview showing off some of the new features. Office LTSC in it’s current preview is underwhelming, to put it mildly. But that’s what Microsoft is aiming for. Office LTSC (Long Term Servicing Channel) for […]
Easy and better lists with Excel 365’s Filter()
Filter is another Excel 365 dynamic array formula that’s really useful and far better than similar options in earlier versions of Excel. Just like SORT() and SORTBY(), FILTER() refreshes automatically whenever the source values change. The older pull-down filter and sort choices don’t update properly. Dynamic Arrays also give you the choice to show the […]
April 2021 updates for Office 365, 2019 and 2016 – Windows
Details and warnings about the April 2021 security and non-security updates for Office 365, Office 2019 and Office 2016 for Windows. There are some side-effects to watch out for. All these update will, or have been, pushed to your computer already. We’ve included a tip on how to force an update to the latest release. […]
April updates for Office 2016, Office 2013 and 2010
Here’s all the security and general bug fixes for April, aimed at Office 2016, Office 2013 and Office 2010 for Windows. Most customers will have their Office updated automatically unless you’re one of the cautious who wait a little while to see if there’s any bugs in the bug fixes. See Why updating Office is […]
Comments have changed for the better in Excel 365
Microsoft has been changing the way comments work in Office 365 and now it’s the turn of Excel 365 to get the new-style conversational comments. If you’ve opened up Excel 365 recently you might have seen a notice like this: “ Comments can now be used for discussions. When you put one in, you’ll see […]
Better live sorting in Excel 365
In late 2018, Excel 365 got an important new feature, Dynamic Arrays . Here’s a simple way to use the feature to make your workbooks sort better and automatically. It also fixes a long-standing problem in Excel. We’re going to focus on a very simple and useful part of dynamic array that anyone can use; […]
