## Concatenating A Range In Excel

One of the things that Excel is missing is a way of joining a range of cell values with a common delimiter such as a comma. Here is an example of a range of cells that would be nice to be able to join together with a comma: A B Read more…

## Understanding Cell References In Excel

One of the commonly misunderstood things about using formulas within Excel is writing cell references. By this, I mean, many people don’t know when to and when not to use the dollar sign before a column name or row number. The dollar sign is used to make the identifier after Read more…

## Using COUNTIF In Excel

Why would you use the COUNTIF function? This is a question that you may wonder at times. First of all, you could use it to figure out how many cells in a range match the specified criteria. You could also use it to determine whether or not a value in Read more…

## Forcing A Constructor In JavaScript

Did you know that you can force a function to only act as a constructor? The following is an example of a Person pseudo-class which can be defined with or without the new keyword: One of the things that you may have noticed is the fact that I am throwing Read more…

## POW – Quick Escape

This is the first of a new series of posts called the “Problem of the Week” (POW). As is evidenced by the title, these problems will be posted weekly. Every Sunday, I will post the answer to the previous week’s POW. Problem You are a member on a team of Read more…

## Divisibility Rules for 11 and 12

On Wednesday I explained how to determine if a number is divisible by 3, 6, and/or 9. I also posted a comment with a link to rules for 2, 3, 4, 5, 6, 7, 8, 9, and 10. Therefore, I think it is time for 11 and 12. Divisibility Rule Read more…

###### Blog

In different browsers, there are different ways to view saved passwords. If you don’t know how to do it in your password, and you are fortunate enough to find this page š , you could you simply do the following: Go to the page where your password is saved. Copy Read more…

## Divisibility By Three, Six & Nine

When people say that being able to do simple math is what counts the most, they may not be far off. Did you know that as long as you can add, you can look at any number and tell whether or not the number is evenly divisible by three and/or Read more…

## Solid Type Checking Functions

Now Available in YourJS John Resig definitely has some awesome code inside of jQuery. One of the things that I think is cool is how jQuery does type checking. After looking through the code, I developed my own flavor of functions using the same principle. Here is the code that Read more…