Together with the ISERROR and SEARCH functions, this formula will allow you to scan a column for a certain word (e.g. "apple") and place a code (e.g. "A") into the adjacent cell each time the word is ...

You'll have to use date to calculate the current date in the proper format and hard-code the local zipcode into the function. As with most sites, the HTML generated by the Almanac.com result is not ...

If you study the code, the two averaging functions, average2x and averagethird, are almost the same. The only difference is the one point where the math is different. Now look at this version.