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 →
{ 1 Comments }
In range B3:B7, assume the following values: 12,34-,23,6-,8. As can be observed, the minus sign is appearing after the number thereby treating 34- and 6- as text values. The objective is to place the minus sign before the number so that all values in range B3:B7 can be added. Since data is in one column […]
Read More →
Select a large data set which has blank rows and columns without using the Shift and arrow keys
{ 2 Comments }