Tags: WILDCARDS

Select a large data set which has blank rows and columns without using the Shift and arrow keys

{ 2 Comments }

Assume a large data set spanning many rows and columns.  In the data set are entirely blank rows and columns.  As an example, let’s say data is in range A2:G5000, then from A5005:J87634 and then from A87636:F92345.  Furthermore, assume that columns H and I are completely blank.  Data in the filled up cells can be […]

Read More →

Count text values in a range

{ 0 Comments }

In range C4:C10, assume the following values/formulas 1. Cell C4 – 1 2. Cell C5 – 2 3. Cell C6 – W 4. Cell C7 – We 5. Cell C8 – Empty cell 6. Cell C9 =IF(D9+E9=2,”a”,””).  Please ensure that cells D9:E9 are empty 7. Cell C10 =1/0.  This will yield the #DIV/0! error To count numbers […]

Read More →