Show the cells to be removed by Remove Duplicates in Excel
Excel has a Remove Duplicates option in the Data ribbon. It keeps the first item and removes any further items that match.
(more…)Excel Power Query and Data Types
Data types are an important part of Power Query in Excel and Power BI. They define the type of data that should be in a column. When performing some calculations, getting the column data type right is vital.
(more…)Display a New Window
If you have two or more screens (I have three) you can have separate Excel windows on separate screens. This can make copying and linking much easier. The keyboard shortcut to open a new window in the current file is Alt W N pressed in sequence not held down. This allows you to have the same file visible in two separate windows. Each window can have a separate sheet. The New Window icon is on the View ribbon tab.
Excel and Emojis
Yes, you can use emojis (those little images you see in text messages, tweets and posts) in Excel. You can even use them in formulas. I am not saying you should use them, just that you can.
(more…)Conditional Format to Display Only the First Entry
In my previous blog post I showed a technique to reduce clutter. The technique used a manual formatting method. Here is the automated version. You can see my previous post here. Below is the original table. We can use a Conditional Format to only display the first entry of each date in the Date column. Select the range A2:A11. Click the Conditional Formatting drop down and select New Rule (third from the bottom). Select the last option in the top…