Total Pageviews

Friday, 14 June 2013

Excel 2010: Functions


  1. 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.
  2. 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.

No comments:

Post a Comment