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...]
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...]
Using F9 To Evaluate An Excel Formula
by Barbara

Hello, Excellers. Welcome back to another #Excel #FormulaFriday blog post in my 2021 Excel series. This blog post in response to a question asked by a subscriber. They wanted to 'see' the different parts of their Excel formula. Or in their words how to understand how each part of the formula is calculated. So, this is exactly the same as debugging an excel formula. There is a great way to do this in Excel. It's simple, by using the F9 … [Read more...]
- 1
- 2
- 3
- …
- 53
- Next Page »