Special Tricks/Features in Sample Files
There are too many different "tricks" to have an exhausting list. A few sample files are included here which may be of use. You can view the files or you can save the files to your desktop. Right-Click on the respective links and choose the option Save Target As if you want to save the document on your computer.
Example 1: Some holiday dates are obvious, like Christmas (December 25) or New Years Day (Jan 1). Others are not quite so obvious. For example, Martin Luther King's Birthday is celebrated on the third Monday in January. When is that? For what year? This example contains some of the obvious and the not so obvious holidays.
Example 2: Sometimes you may need to calculate some arithmetic process using numbers in a list (i.e. sum) but you want to use a partial collection of numbers in a list, say those numbers greater than a certain value. You may want to be able to input a criteria for selecting which numbers to use in your calculations. This example shows you how.
Example 3: If you have a range of numbers of range of text, you may need to count the number of cells that contain a specific number or a specific text or numbers if they are greater than some value or ... (you get the idea).
Example 4: Similar to Example 3, you may want to count based on multiple criteria (And, Or). This example shows you how.
Example 5: (That's all for now - check back for updates.)