Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...

The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally and mathematically correct. The SCAN function has three arguments: ...

There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code. A basic form can be very useful if you need to enter a lot of data into Excel ...

I have a background that includes spreadsheets, programming, and electronics, so this book piqued my interest. I didn't run into any surprises until I thought a bit more about its contents and my ...