With any software, the more you use it, the more hacks and shortcuts you discover, and never a truer word has been said when ...

Example: I have a 5 x 5 array of data with names of animals in it. I have another cell with "monkey" written in it. Is there a way I can write a formula to test whether or not "monkey" exists in the ...

Using just one formula, you can create an entire table, generate a filtered view, calculate a running total, or build a ...

Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly spaced, but there are times you will need to group ...