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…
Tag: file
Square Symbol in Excel
In order to insert a square symbol in Excel, you have to do the following.
Count Rows in Excel VBA
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…
Insert a Picture Into a Cell in Excel
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…
Check if a Cell Contains a Substring in Excel
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…
Pivot Table Count Unique Values
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) |
Leave a Cell Blank if the Condition Is False
The following formula will check cell A1, and if the condition is False (value != 2) it returns blank, otherwise (value = 2)…
Sumproduct
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…
Degree Symbol in Excel
The degree symbol can be used in geometry or in determining geographical coordinates. This special symbol can be inserted. There are a few…
Too Many Different Cell Formats in Excel
When you use Excel 2003 you may encounter the “too many cell formats” error, just after you try to open a file. This…