- search: The syntax for the SEARCH function is: SEARCH( substring, string, [start_position] )
- substring is the substring that you want to find.
- string is the string to search within.
- start_position is optional. It is the position in string where the search will start. The first position is 1.
- The first implementation of the INDEX function returns the value from a table or range. The syntax for the INDEX function is: INDEX( array, row_number, [column_number] )
- array is a range of cells or table.
- row_number is the row number in the array to use to return the value.
- column_number is optional. It is the column number in the array to use to return the value.
Total Pageviews
Friday, 14 June 2013
Excel 2010: Functions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment