Hello Excellers, welcome to another #Excel #FormulaFriday blog post in my 2021 series. Today let’s explore the Filter function in Excel. We can output only the positive values from a column of data using this function. This newly released function is part of the DYNAMIC Array functions announced by Microsoft back in 2018. At that time these array functions were only beta release available to a portion of Office insiders. Microsoft announced … [Read more...]
Compare Two Ranges With Conditional Formatting.

Hello, Excellers. Welcome to another #Exceltips #FormulaFriday blog post in my Excel 2021 series. The comparison of two Excel ranges for any differences is a common task. One way to do this to use conditional formatting to highlight differences between the two ranges. Take a look at my two lists below. I have an original list and a new list. Let's go ahead and make the differences in these two lists stand out with conditional formatting. First I want to create named ranges … [Read more...]
Find The Last Value In An Excel Column.

Hello, Excellers. Welcome back to another #Excel #FormulaFriday blog post in my Excel 2021 series. Today I will answer a question that was left on one of my YouTube Videos. The question left was the same multiple times. How do I find the last value in an Excel column?. My video actually walks you through how to find the last value in an Excel row using the Index and Count Function. I have put a link below that video. https://youtu.be/n6odmvo0srY So, here is how to find the last … [Read more...]
A Paste Special Trick To Convert A Number To A Percentage.

Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage) formatting missing?. If you ever have tried to correct this then you know you could try to adjust the formatting of the cell. But, that just ends up looking like the screenshot below right?. Who wants to edit each cell with %?. Well, by using Paste Special we can … [Read more...]
Find Your Cells that Contain Formulas- Quickly

Hello, Excellers. Welcome back to another #FormulaFriday #ExcelTips blog post in my 2021 Excel series. Today let's take a look at how to quickly find your cells that contain formulas. Have you ever inherited a workbook? Have you ever been asked to update an Excel workbook?. Do you need to see which cells contain Excel formulas?. Also, do you need to quickly check the referencing of your formulas to ensure they are correct?. So, I would say that no-one wants to manually check each … [Read more...]
- 1
- 2
- 3
- …
- 86
- Next Page »