Topic: User Defined Functions

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Automatically Converting to GMT Greenwich Meridian Time, or GMT, is a common reference time used around the world. If you want to convert a time to GMT, this tip provides the information you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Converting Between Buddhist and Gregorian Calendar Systems Using the DATE function to convert a calendar system. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Counting Colors of Cells Many people use colors of cells as a common method of communicating information in a worksheet. If you need a way to count cells that are formatted with a certain color, then the user-defined function in this tip will come in very handy. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Determining Combinations to Make a Total Determining how to create combinations of various elements to achieve a desired total can be frustrating. This tip takes a look at how to accomplish such a task using a user-defined function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Generating Unique Sequential Numbers Using Excel to generate unique sequential numbers for invoices or company statements. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Looking Up Names when Key Values are Identical Do you have a list in which there are duplicates in the key field, and you want to look up non-duplicate values associated with those keys? This type of problem can be more common than most people think, and it is definitely more vexing than most problems. This tip explains several ways you can find the information you need from your list. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Modifying Proper Capitalization The PROPER worksheet function is used to change the case of text so that the first letter of each word is capitalized. If there are some words you don’t want to have an initial cap, then you’ll want to use the ideas presented in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Returning a Weight and a Date If you have two columns containing dates and weights from those dates, you may want to pick a date associated with a given weight. It’s easy to do using just a few Excel worksheet functions. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Sorting by Fill Color Sorting data in a worksheet is easy, unless you want to sort by the color used to fill a range of cells. There are ways to do the sorting, however, as illustrated in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Weekdays in a Month Excel has no intrinsic formulas that allow you to determine how many of a particular weekday occur within a month. You can create such a formula, however, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Perplexed by Pivots?

Helpful Links

Great Info!

RSS Feeds