Drop Down List in Excel Made Easy

A drop down list in Excel allows users to pick a value from a restricted set. By providing user a choice and yet preventing impermissible values, drop down lists help make your spreadsheets interactive and foolproof. While there are more than 1 way to make them, the most commonly used method is using data validation. You can create both static and dynamic drop down lists in Excel - the later re-sizing themselves as newer values ...

Continue Reading

Drop Down List in Excel Made Easy

INDEX Formula Excel – How to use Excel INDEX Function

Posted on 26 August 2009

INDEX Formula Excel - How to use Excel INDEX Function
Syntax of INDEX Formula Example of INDEX Formula Possible Errors returned by the INDEX Formula INDEX formula in Excel returns the cell at the intersection of a particular row and column within a range. The INDEX formula is typically used to locate a value in a given range by specifying its X-Y coordinates (i.e. the row and the column) within the range. INDEX Formula Syntax INDEX Formula has four parts: INDEX (range_to_search_in, row_position, column_position, range_number) ...
Continue Reading

Comments (2)

DATE Formula Excel – How to use Excel DATE Function

Posted on 23 July 2009

DATE Formula Excel - How to use Excel DATE Function
Syntax of DATE Formula Example of DATE Formula Possible Errors returned by the DATE Formula DATE formula in Excel returns the number representing the date for a given day, month and year. The DATE formula is typically used to construct a date by providing the constituting parts such as day, month and year. The minimum and maximum values that a date can take is Office 2003 is January 1, 1900 and December 31, 9999 (if that existed). DATE Formula ...
Continue Reading

Comments (63)

MATCH Formula Excel – How to use Excel MATCH Function

Posted on 13 July 2009

MATCH Formula Excel - How to use Excel MATCH Function
Syntax of MATCH Formula Example of MATCH Formula Possible Errors returned by the MATCH Formula MATCH formula in Excel returns the relative position of a value in an array or a range MATCH Formula Syntax MATCH Formula has three parts: MATCH (value_to_find, range_to_find_value_in, match_type) value_to_find value_to_find is the value which we are trying to find. It can be a number or a string. If the value_to_find is specified as a ...
Continue Reading

Comments (5)

ADDRESS Formula Excel – How to use Excel ADDRESS Function

Posted on 10 July 2009

ADDRESS Formula Excel - How to use Excel ADDRESS Function
Syntax of ADDRESS Formula Example of ADDRESS Formula Possible Errors returned by the ADDRESS Formula ADDRESS formula in Excel generates the address for a cell when provided a row and a column number. ADDRESS Formula Syntax ADDRESS Formula has five parts: ADDRESS (row_num, col_num, ref_type, ref_style, sheet_name) row_num row_num is the row number in which the cell for which you are trying to generate the address is located. It is ...
Continue Reading

Comments (6)

Array Formulas in Excel – Excel Array Formula Syntax & Array Constants

Posted on 05 July 2009

Array Formulas in Excel - Excel Array Formula Syntax & Array Constants
Array Formulas in Excel An Array Formula in excel is a formula that uses arrays instead of single cell value as input. Excel Array Formulas can be thought of as many formulas packed into a single super formula. In this article we will take a look at the syntax of an array formula, its various parts, learn how to write a basic array formula and then graduate on to writing the more powerful versions of it. Before we begin, let ...
Continue Reading

Comments (21)

COUNTIF Formula Excel – How to use Excel COUNTIF Function

Posted on 04 July 2009

COUNTIF Formula Excel - How to use Excel COUNTIF Function
Syntax of COUNTIF Formula Example of COUNTIF Formula Possible Errors returned by the COUNTIF Formula COUNTIF formula in Excel counts the numbers of cells in a range that meet the given condition. COUNTIF Formula Syntax COUNTIF Formula has two parts: COUNTIF (range, criteria) range range is the range in which the value that you are trying to find out is located. criteria criteria is the value whose occurence in the above range we would like to count. ...
Continue Reading

Comments (4)

IF Formula Excel – How to use Excel IF Function

Posted on 04 July 2009

IF Formula Excel - How to use Excel IF Function
IF formula in Excel checks whether a given condition evaluates TRUE or FALSE. Syntax of IF Formula Example of IF Formula Possible Errors returned by the IF Formula IF Formula Syntax IF Formula has three parts: IF(criteria, value_when_true, value_when_false) criteria criteria is the condition that we would like to evaluate for being TRUE or FALSE. value_when_true value_when_true is the value that will be returned by the function when the above criteria evaluates to TRUE. This ...
Continue Reading

Comments (12)

VLOOKUP Formula Excel – How to use Excel VLOOKUP Function

Posted on 01 July 2009

VLOOKUP Formula Excel - How to use Excel VLOOKUP Function
Syntax of VLOOKUP Formula Example of VLOOKUP Formula Possible Errors returned by the VLOOKUP Formula VLOOKUP formula matches a string against the 1st column of a range and returns any cell value from the matched row. VLOOKUP Formula Syntax VLOOKUP Formula has three parts: VLOOKUP (value_to_find, range_to_search_in, column_number_to_return, match_type) value_to_find value_to_find is the value that we would like to find. You can specify a string, a number or a cell ...
Continue Reading

Comments (22)

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES