!data_field,pivot_table,field,item,...!!Extracts data stored in a PivotTable.!is the name of the data field to extract data from!is a reference to a cell or range of cells in the PivotTable that contains the data you want to retrieve!field to refer to!field item to refer to!
database,field,criteria!Multiplies the values in the field (column) of records in the database that match the conditions ...
database,field,criteria!Returns the largest number in the field (column) of records in the database that match the conditions ...
database,field,criteria!Returns the smallest number in the field (column) of records in the database that match the conditions ...
data_array,bins_array!Calculates how often values occur within a range of values and then returns a vertical array of numbers ...
data_field,pivot_table,field,item,.!Extracts data stored in a PivotTable.!is the name of the data field to extract data from!is ...
Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to ...
date_text!Converts a date in the form of text to a number that represents the date in Microsoft Office Excel date-time code!is ...
decimal_dollar,fraction!Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction!is ...
DeepPink\0Magenta\0Fuchsia\0Violet\0BlueViolet\0Plum\0Orchid\0Thistle\0MediumOrchid\0DarkViolet\0DarkOrchid\0MediumViole ...