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...]
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...]
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...]
Formula Friday- 3 Fastest Ways To Apply A Formula To An Entire Column Or Row In Excel
Happy Friday Excellers, time for more #FormulaFriday Excel Fun. Today I want to show you how the 3 fastest ways to apply a formula to an entire column or row. I am always looking for ways to be be more efficient when working in Excel especially when it comes to formulas. Sometimes you may have to apply a formula to hundreds or even thousands of Columns or Rows in your Excel worksheet. So, let's look at the 3 fastest ways to apply your Excel formula to an entire Column or Row. Method 1. … [Read more...]
Formula Friday – Move Your Formula Quickly Around Your Excel Worksheet Without Changing Cell References
Hello Excellers, welcome back to another #FormulaFriday, in my Excel 2020 series. Today it is a somewhat zippy quick Formula tip. I will show you how to move your formula quickly around your Excel worksheet without changing cell references. Relative cell referencing in Excel is one of it's most powerful features. But, when you copy a formula to a new location in your worksheet or workbook, then all of the relative cell addresses also change. I dont always want this to happen. Sometimes … [Read more...]
- 1
- 2
- 3
- …
- 50
- Next Page »
Recommended Excel Resources
