Leading the way in Microsoft Office Development

Reference Articles - 2007

2007: An xlfn. prefix is displayed in front of a formula

Reference Articles - 2003

2003: About nesting functions within functions

2003: About projecting values

2003: About the syntax of functions

2003: Calculate a running balance

2003: Calculate a running total

2003: Calculate the average of a group of numbers

2003: Calculate the factorial or permutation of a number

2003: Calculate the median of a group of numbers

2003: Calculate the mode of a group of numbers

2003: Calculate the smallest or largest number in a range

2003: Change the case of text

2003: Check if a cell contains text (case-insensitive)

2003: Check if a cell contains text (case-sensitive)

2003: Check if a number is greater than or less than another number

2003: Combine first and last names

2003: Combine text and numbers

2003: Combine text with a date or time

2003: Combine two or more columns by using a function

2003: Convert Arabic to Roman numerals

2003: Convert measurements

2003: Convert numbers to different number systems

2003: Count all of the cells in a range

2003: Count cells that contain numbers

2003: Count how often a value occurs

2003: Count nonblank cells

2003: Count numbers greater than or less than a number

2003: Count the number of words in a cell or range

2003: Count unique values among duplicates

2003: Display only the last four digits of identification numbers

2003: Examples of commonly used formulas

2003: Extracting numbers from alphanumeric strings

2003: Hide error values and error indicators in cells

2003: How to look up a value in a list and return multiple corresponding values

2003: Look up values in a list of data

2003: More ways to use HLookup and VLookup functions

2003: Project values

2003: Raise a number to a power

2003: Remove characters from text

2003: Remove spaces and nonprinting characters from text

2003: Repeat a character in a cell

2003: Round a number

2003: Split text among columns by using functions

2003: Summing up ways to add and count Excel data

2003: Troubleshoot euro currency conversion

2003: Use Excel in the due diligence process

2003: Use HLookup and VLookup functions to find records in large worksheets

2003: Using the CALL and REGISTER Functions

2003: Using worksheet functions for quality control

2003: View converted values for euros and other currencies

Reference Articles - 2002

2002: Inserting the current Excel file name in a cell

2002: Use a function to get a stock quote

Reference Articles - 2000

2000: Average more than 30 numbers in Excel 97/2000

2000: Create a euro conversion table in Excel

2000: Count the unique entries in a column of data

2000: Insert the filename in a cell