## Chart Ignore Blank Cells in Excel

When you create a chart, sometimes you will find blank cells in rows. If you insert a line chart there your data won’t…

When you create a chart, sometimes you will find blank cells in rows. If you insert a line chart there your data won’t…

In order to insert a square symbol in Excel, you have to do the following.

There are a few methods to count rows and each of them uses VBA. In this example, I’ll show two of them. Range.End…

Let’s say that you want to create a table in order to add new images. The problem is that the images won’t behave…

Case insensitive In order to check whether a cell contains a substring in a text, use the following formula.

1 |
=ISNUMBER(SEARCH(substring,string)) |

The following formula…

In order to count unique values in the Pivot Table, you have to do the following steps.

1 |
=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) |

The following formula will check cell A1, and if the condition is False (value != 2) it returns blank, otherwise (value = 2)…

The SUMPRODUCT function is the combination of addition (SUM…) and multiplication (…PRODUCT). It gets one or more arrays and returns the sum of products of…

The degree symbol can be used in geometry or in determining geographical coordinates. This special symbol can be inserted. There are a few…

When you use Excel 2003 you may encounter the “too many cell formats” error, just after you try to open a file. This…