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...]
Create A Yes No Message Box Before Running An Excel Macro.

Welcome back to another blog post in my #ExcelTips #MacroMonday Excel 2021 series. There a few ways to run an Excel macro. Hit the F5 key or the Run button while in the VBA window. But, sometimes a giving the user a warning before the macro is run, or ask if they are sure they want to run it the macro is a good safety net. The Yes No message box is a really good way to do this. The logic is simple. Hit Yes and the code or macro runs. Hit No, the code stops running. You are asking are you … [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...]
Convert All Formulas Into Values Excel Macro.

Hello Excellers and welcome back to another #MacroMonday blog post in my #Excel 2020 Excel tips series. Today we will write an Excel macro that will very quickly convert all of your formulas into values. Yes, that is correct, this macro will convert all Excel formulas into absolute values with one click of the mouse. Prepare To Write The Macro. First, open the Visual Basic Editor. There are two ways to do this. Hit ALT +F11 orSelect the Developer Tab | Code … [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...]
- 1
- 2
- 3
- …
- 98
- Next Page »