Hello Excellers and welcome back to another Excel blog post in my #Excel Formula Friday 2020 series. Today, we deal with a formula error. Let me show you how to deal with the #DIV/0!, divide by zero formula error in Excel. We have all been there I am sure, all is going well when you have written your Excel formula. You have dragged it down your column of data and there it is, one big ugly divide by zero formula error. Some Excel users do not mind the #DIV/0!, divide by zero error. I … [Read more...]
Macro Mondays – How To Write A Macro To Delete All Hyperlinks In Your Excel Workbook
Hello Excellers, time for some more Excel VBA macro Fun. It is time for another #Excel #macro Monday post in my 2020 series. I want to answer a question from a subscriber. They needed to delete all of their hyperlinks. They had a worksheet with 50+ tabs and hyperlinks on all of them. The usual method of deleting hyperlinks was not working select the cells that contain the hyperlinks Right Click Delete Hyperlinks You would expect maybe to be able to simply group all of your worksheets and … [Read more...]
Find Missing Values In Excel. Formula Friday
Hello, Excellers welcome back for another Excel blog post in my 2020 series where I share my #FormulaFriday #Excel tips. Today let's look at a really handy Excel formula or a number of formulas that will tell us what numbers are missing in a sequenced data set. Cool huh?. Let's get writing that formula to find those missing values in Excel. We are going to use a number of Excel formulas. We will begin with the logical IF Function. Here is my sample data set. I can clearly see that some … [Read more...]
Enable Your Personal Macro Workbook. Help! Where Did It Go?.
Hello Excellers and welcome back for another #Excel #MacroMonday blog post in my Excel 2020 series. Today is a quick (ish) macro or VBA tip in response to a question I have been asked recently. A subscriber could not find or locate any Macros they had stored in their Personal Macro Workbook. Where had ALL that work gone?. Where were the missing macros?. They were freaking out. (Of Course!). Their Personal Macro Workbook was missing. The Personal Macro Workbook was not showing up in the … [Read more...]
Count How Many Cells Have Negative Or Positive Numbers. (COUNTIF).
Hello Excellers and welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today we will look at how to count how many cells have negative and positive numbers. To do this we can use the COUNTIF Function in Excel. COUNTIF Function. COUNTIF is an Excel Function which counts cells that meet a specific single condition. It is used to count cells that contain text, numbers or dates. We can also use operators such a >,< and =. So, in the scenario for … [Read more...]
- 1
- 2
- 3
- …
- 81
- Next Page »
Recommended Excel Resources
