Adding errors, texts, numbers, blanks in a list

A quick post. Here is how you can you can count errors, blanks, numbers, texts in a list. List A2:A11 is defined as Count_list To count Errors       {=SUM(IF(ISERROR(Count_list),1,0))} Blanks       {=SUM(IF(ISBLANK(Count_list),1,0))} Numbers {=SUM(IF(ISNUMBER(Count_list),1,0))} Text           {=SUM(IF(ISTEXT(Count_list),1,0))} The formulas are entered as array formuals with ctrl+shift+enter

Read Full Post »

Handling errors in excel

I have listed down the types of error in excel and their likely causes in the table below:      Error type can be found out through the formula =Error.Type(cell_ref) Count instances of error One of the ways to count the total occurence of error in an area is this {=SUM(IF(ISERROR(B2:B8),1,0))} entered as an array formula [...]

Read Full Post »

Create spaces within a list

This is a very interesting problem that we encountered. To simplify the problem, the objective of the exercise was to insert spaces within a continuous list. For example   Column A has the original list and column D has the desired result. Two blank cells needed to be inserted between the entries. To solve this problem, [...]

Read Full Post »