Last active
August 9, 2023 18:35
-
-
Save lhem/37e252ccd6ae700a12f3091cb16bd64b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Lookup worksheet and macro function information | |
// Resources: | |
// https://learn.microsoft.com/en-us/office/client-developer/excel/welcome-to-the-excel-software-development-kit | |
// https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 | |
// https://www.myonlinetraininghub.com/excel-4-macro-functions | |
// https://github.com/lhem/excel/wiki/Functions | |
// Notes: | |
// legacy functions included e.g. =fnLookup("SINGLE") | |
// Parameter and return types can include one or more of: | |
// [v] number, text, logical, error, datatype, image, lambda, null | |
// [a] array e.g. select ';var' -> variant array returned | |
// [r] reference e.g. select ',vr' -> dereferencing needed to spill | |
fnLookup=LAMBDA(fnName, | |
IFNA( | |
TRANSPOSE(TEXTSPLIT(VLOOKUP(fnName & ",*", fnAll, 1, 0), ",", ";")), | |
IF(MATCH(fnName, fnAll, 0), HSTACK(fnName,"macro")) | |
) | |
); | |
fnAll | |
=VSTACK( | |
fnCompatibility, | |
fnCube, | |
fnDatabase, | |
fnDateTime, | |
fnEngineering, | |
fnFinancial, | |
fnInformation, | |
fnLogical, | |
fnLookupReference, | |
fnMathTrig, | |
fnMisc, | |
fnStatistical, | |
fnText, | |
fnWeb, | |
fnMacro | |
); | |
fnCompatibility | |
={ | |
"BETADIST,x,alpha,beta,[A],[B];v,v,v,v,v,v,v"; | |
"BETAINV,probability,alpha,beta,[A],[B];v,v,v,v,v,v"; | |
"BINOMDIST,number_s,trials,probability_s,cumulative;v,v,v,v,v"; | |
"CEILING,number,significance;v,v,v"; | |
"CHIDIST,x,deg_freedom;v,v,v"; | |
"CHIINV,probability,deg_freedom;v,v,v"; | |
"CHITEST,actual_range,expected_range;v,v,v,v"; | |
"CONCATENATE,text1,[text2],...;v,v,v,v"; | |
"CONFIDENCE,alpha,standard_dev,size;v,v,v,v"; | |
"COVAR,array1,array2;v,a,a"; | |
"CRITBINOM,trials,probability_s,alpha;v,v,v,v"; | |
"EXPONDIST,x,lambda,cumulative;v,v,v,v"; | |
"FDIST,x,deg_freedom1,deg_freedom2;v,v,v,v"; | |
"FINV,probability,deg_freedom1,deg_freedom2;v,v,v,v"; | |
"FLOOR,number,significance;v,v,v"; | |
"FORECAST,x,known_y's,known_x's;v,v,a,a"; | |
"FTEST,array1,array2;v,a,a"; | |
"GAMMADIST,x,alpha,beta,cumulative;v,v,v,v"; | |
"GAMMAINV,probability,alpha,beta;v,v,v,v"; | |
"HYPGEOMDIST,sample_s,number_sample,population_s,number_pop;v,v,v,v,v"; | |
"LOGINV,probability,mean,standard_dev;v,v,v,v"; | |
"LOGNORMDIST,x,mean,standard_dev;v,v,v,v"; | |
"MODE,number1,[number2],...;v,a,a,a"; | |
"NEGBINOMDIST,number_f,number_s,probability_s;v,v,v,v"; | |
"NORMDIST,x,mean,standard_dev,cumulative;v,v,v,v,v"; | |
"NORMINV,probability,mean,standard_dev;v,v,v,v"; | |
"NORMSDIST,z;v,v"; | |
"NORMSINV,probability;v,v"; | |
"PERCENTILE,array,k;v,var,v"; | |
"PERCENTRANK,array,x,[significance];v,var,v,v"; | |
"POISSON,x,mean,cumulative;v,v,v,v"; | |
"QUARTILE,array,quart;v,var,v"; | |
"RANK,number,ref,[order];v,v,r,v"; | |
"STDEV,number1,[number2],...;v,var,var,var"; | |
"STDEVP,number1,[number2],...;v,var,var,var"; | |
"TDIST,x,deg_freedom,tails;v,v,v,v"; | |
"TINV,probability,deg_freedom;v,v,v"; | |
"TTEST,array1,array2,tails,type;v,a,a,v,v"; | |
"VAR,number1,[number2],...;v,var,var,var"; | |
"VARP,number1,[number2],...;v,var,var,var"; | |
"WEIBULL,x,alpha,beta,cumulative;v,v,v,v,v"; | |
"ZTEST,array,x,[sigma];v,var,v,v" | |
}; | |
fnCube | |
={ | |
"CUBEKPIMEMBER,connection,kpi_name,kpi_property,[caption];v,v,v,v,v"; | |
"CUBEMEMBER,connection,member_expression,[caption];v,v,var,v"; | |
"CUBEMEMBERPROPERTY,connection,member_expression,property;v,v,v,v"; | |
"CUBERANKEDMEMBER,connection,set_expression,rank,[caption];v,v,v,v,v"; | |
"CUBESET,connection,set_expression,[caption],[sort_order],[sort_by];v,v,var,v,v,v"; | |
"CUBESETCOUNT,set;v,v"; | |
"CUBEVALUE,connection,[member_expression1],...;v,v,var,var" | |
}; | |
fnDatabase | |
={ | |
"DAVERAGE,database,field,criteria;v,r,vr,vr"; | |
"DCOUNT,database,field,criteria;v,r,vr,vr"; | |
"DCOUNTA,database,field,criteria;v,r,vr,vr"; | |
"DGET,database,field,criteria;v,r,vr,vr"; | |
"DMAX,database,field,criteria;v,r,vr,vr"; | |
"DMIN,database,field,criteria;v,r,vr,vr"; | |
"DPRODUCT,database,field,criteria;v,r,vr,vr"; | |
"DSTDEV,database,field,criteria;v,r,vr,vr"; | |
"DSTDEVP,database,field,criteria;v,r,vr,vr"; | |
"DSUM,database,field,criteria;v,r,vr,vr"; | |
"DVAR,database,field,criteria;v,r,vr,vr"; | |
"DVARP,database,field,criteria;v,r,vr,vr" | |
}; | |
fnDateTime | |
={ | |
"DATE,year,month,day;v,v,v,v"; | |
"DATEDIF,start_date,end_date,unit;v,v,v,v"; | |
"DATEVALUE,date_text;v,v"; | |
"DAY,serial_number;v,v"; | |
"DAYS,end_date,start_date;v,v,v"; | |
"DAYS360,start_date,end_date,[method];v,v,v,v"; | |
"EDATE,start_date,months;v,vr,vr"; | |
"EOMONTH,start_date,months;v,vr,vr"; | |
"HOUR,serial_number;v,v"; | |
"ISOWEEKNUM,date;v,v"; | |
"MINUTE,serial_number;v,v"; | |
"MONTH,serial_number;v,v"; | |
"NETWORKDAYS,start_date,end_date,[holidays];v,vr,vr,var"; | |
"NETWORKDAYS.INTL,start_date,end_date,[weekend],[holidays];v,vr,vr,v,var"; | |
"NOW;v"; | |
"SECOND,serial_number;v,v"; | |
"TIME,hour,minute,second;v,v,v,v"; | |
"TIMEVALUE,time_text;v,v"; | |
"TODAY;v"; | |
"WEEKDAY,serial_number,[return_type];v,v,v"; | |
"WEEKNUM,serial_number,[return_type];v,vr,vr"; | |
"WORKDAY,start_date,days,[holidays];v,vr,vr,var"; | |
"WORKDAY.INTL,start_date,days,[weekend],[holidays];v,vr,vr,v,var"; | |
"YEAR,serial_number;v,v"; | |
"YEARFRAC,start_date,end_date,[basis];v,vr,vr,vr" | |
}; | |
fnEngineering | |
={ | |
"BESSELI,x,n;v,vr,vr"; | |
"BESSELJ,x,n;v,vr,vr"; | |
"BESSELK,x,n;v,vr,vr"; | |
"BESSELY,x,n;v,vr,vr"; | |
"BIN2DEC,number;v,vr"; | |
"BIN2HEX,number,[places];v,vr,vr"; | |
"BIN2OCT,number,[places];v,vr,vr"; | |
"BITAND,number1,number2;v,v,v"; | |
"BITLSHIFT,number,shift_amount;v,v,v"; | |
"BITOR,number1,number2;v,v,v"; | |
"BITRSHIFT,number,shift_amount;v,v,v"; | |
"BITXOR,number1,number2;v,v,v"; | |
"COMPLEX,real_num,i_num,[suffix];v,vr,vr,vr"; | |
"CONVERT,number,from_unit,to_unit;v,vr,vr,vr"; | |
"DEC2BIN,number,[places];v,vr,vr"; | |
"DEC2HEX,number,[places];v,vr,vr"; | |
"DEC2OCT,number,[places];v,vr,vr"; | |
"DELTA,number1,[number2];v,vr,vr"; | |
"ERF,lower_limit,[upper_limit];v,vr,vr"; | |
"ERF.PRECISE,X;v,vr"; | |
"ERFC,x;v,vr"; | |
"ERFC.PRECISE,X;v,vr"; | |
"GESTEP,number,[step];v,vr,vr"; | |
"HEX2BIN,number,[places];v,vr,vr"; | |
"HEX2DEC,number;v,vr"; | |
"HEX2OCT,number,[places];v,vr,vr"; | |
"IMABS,inumber;v,vr"; | |
"IMAGINARY,inumber;v,vr"; | |
"IMARGUMENT,inumber;v,vr"; | |
"IMCONJUGATE,inumber;v,vr"; | |
"IMCOS,inumber;v,vr"; | |
"IMCOSH,inumber;v,vr"; | |
"IMCOT,inumber;v,vr"; | |
"IMCSC,inumber;v,vr"; | |
"IMCSCH,inumber;v,vr"; | |
"IMDIV,inumber1,inumber2;v,vr,vr"; | |
"IMEXP,inumber;v,vr"; | |
"IMLN,inumber;v,vr"; | |
"IMLOG10,inumber;v,vr"; | |
"IMLOG2,inumber;v,vr"; | |
"IMPOWER,inumber,number;v,vr,vr"; | |
"IMPRODUCT,inumber1,[inumber2],...;v,var,var,var"; | |
"IMREAL,inumber;v,vr"; | |
"IMSEC,inumber;v,vr"; | |
"IMSECH,inumber;v,vr"; | |
"IMSIN,inumber;v,vr"; | |
"IMSINH,inumber;v,vr"; | |
"IMSQRT,inumber;v,vr"; | |
"IMSUB,inumber1,inumber2;v,vr,vr"; | |
"IMSUM,inumber1,[inumber2],...;v,var,var,var"; | |
"IMTAN,inumber;v,vr"; | |
"OCT2BIN,number,[places];v,vr,vr"; | |
"OCT2DEC,number;v,vr"; | |
"OCT2HEX,number,[places];v,vr,vr" | |
}; | |
fnFinancial | |
={ | |
"ACCRINT,issue,first_interest,settlement,rate,par,frequency,[basis],[calc_method];v,vr,vr,vr,vr,vr,vr,vr,vr"; | |
"ACCRINTM,issue,settlement,rate,par,[basis];v,vr,vr,vr,vr,vr"; | |
"AMORDEGRC,cost,date_purchased,first_period,salvage,period,rate,[basis];v,vr,vr,vr,vr,vr,vr,vr"; | |
"AMORLINC,cost,date_purchased,first_period,salvage,period,rate,[basis];v,vr,vr,vr,vr,vr,vr,vr"; | |
"COUPDAYBS,settlement,maturity,frequency,[basis];v,vr,vr,vr,vr"; | |
"COUPDAYS,settlement,maturity,frequency,[basis];v,vr,vr,vr,vr"; | |
"COUPDAYSNC,settlement,maturity,frequency,[basis];v,vr,vr,vr,vr"; | |
"COUPNCD,settlement,maturity,frequency,[basis];v,vr,vr,vr,vr"; | |
"COUPNUM,settlement,maturity,frequency,[basis];v,vr,vr,vr,vr"; | |
"COUPPCD,settlement,maturity,frequency,[basis];v,vr,vr,vr,vr"; | |
"CUMIPMT,rate,nper,pv,start_period,end_period,type;v,vr,vr,vr,vr,vr,vr"; | |
"CUMPRINC,rate,nper,pv,start_period,end_period,type;v,vr,vr,vr,vr,vr,vr"; | |
"DB,cost,salvage,life,period,[month];v,v,v,v,v,v"; | |
"DDB,cost,salvage,life,period,[factor];v,v,v,v,v,v"; | |
"DISC,settlement,maturity,pr,redemption,[basis];v,vr,vr,vr,vr,vr"; | |
"DOLLARDE,fractional_dollar,fraction;v,vr,vr"; | |
"DOLLARFR,decimal_dollar,fraction;v,vr,vr"; | |
"DURATION,settlement,maturity,coupon,yld,frequency,[basis];v,vr,vr,vr,vr,vr,vr"; | |
"EFFECT,nominal_rate,npery;v,vr,vr"; | |
"FV,rate,nper,pmt,[pv],[type];v,v,v,v,v,v"; | |
"FVSCHEDULE,principal,schedule;v,vr,var"; | |
"INTRATE,settlement,maturity,investment,redemption,[basis];v,vr,vr,vr,vr,vr"; | |
"IPMT,rate,per,nper,pv,[fv],[type];v,v,v,v,v,v,v"; | |
"IRR,values,[guess];v,ar,v"; | |
"ISPMT,rate,per,nper,pv;v,v,v,v,v"; | |
"MDURATION,settlement,maturity,coupon,yld,frequency,[basis];v,vr,vr,vr,vr,vr,vr"; | |
"MIRR,values,finance_rate,reinvest_rate;v,ar,v,v"; | |
"NOMINAL,effect_rate,npery;v,vr,vr"; | |
"NPER,rate,pmt,pv,[fv],[type];v,v,v,v,v,v"; | |
"NPV,rate,value1,[value2],...;v,v,var,var,var"; | |
"ODDFPRICE,settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,[basis];v,vr,vr,vr,vr,vr,vr,vr,vr,vr"; | |
"ODDFYIELD,settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,[basis];v,vr,vr,vr,vr,vr,vr,vr,vr,vr"; | |
"ODDLPRICE,settlement,maturity,last_interest,rate,yld,redemption,frequency,[basis];v,vr,vr,vr,vr,vr,vr,vr,vr"; | |
"ODDLYIELD,settlement,maturity,last_interest,rate,pr,redemption,frequency,[basis];v,vr,vr,vr,vr,vr,vr,vr,vr"; | |
"PDURATION,rate,pv,fv;v,v,v,v"; | |
"PMT,rate,nper,pv,[fv],[type];v,v,v,v,v,v"; | |
"PPMT,rate,per,nper,pv,[fv],[type];v,v,v,v,v,v,v"; | |
"PRICE,settlement,maturity,rate,yld,redemption,frequency,[basis];v,vr,vr,vr,vr,vr,vr,vr"; | |
"PRICEDISC,settlement,maturity,discount,redemption,[basis];v,vr,vr,vr,vr,vr"; | |
"PRICEMAT,settlement,maturity,issue,rate,yld,[basis];v,vr,vr,vr,vr,vr,vr"; | |
"PV,rate,nper,pmt,[fv],[type];v,v,v,v,v,v"; | |
"RATE,nper,pmt,pv,[fv],[type],[guess];v,v,v,v,v,v,v"; | |
"RECEIVED,settlement,maturity,investment,discount,[basis];v,vr,vr,vr,vr,vr"; | |
"RRI,nper,pv,fv;v,v,v,v"; | |
"SLN,cost,salvage,life;v,v,v,v"; | |
"STOCKHISTORY,stock,start_date,end_date,interval,headers,properties1,...;va,v,v,v,v,v,v,v"; | |
"SYD,cost,salvage,life,per;v,v,v,v,v"; | |
"TBILLEQ,settlement,maturity,discount;v,vr,vr,vr"; | |
"TBILLPRICE,settlement,maturity,discount;v,vr,vr,vr"; | |
"TBILLYIELD,settlement,maturity,pr;v,vr,vr,vr"; | |
"VDB,cost,salvage,life,start_period,end_period,[factor],[no_switch];v,v,v,v,v,v,v,v"; | |
"XIRR,values,dates,[guess];v,var,var,vr"; | |
"XNPV,rate,values,dates;v,vr,var,var"; | |
"YIELD,settlement,maturity,rate,pr,redemption,frequency,[basis];v,vr,vr,vr,vr,vr,vr,vr"; | |
"YIELDDISC,settlement,maturity,pr,redemption,[basis];v,vr,vr,vr,vr,vr"; | |
"YIELDMAT,settlement,maturity,issue,rate,pr,[basis];v,vr,vr,vr,vr,vr,vr" | |
}; | |
fnInformation | |
={ | |
"CELL,info_type,[reference];va,v,r"; | |
"ERROR.TYPE,error_val;v,v"; | |
"INFO,type_text;v,v"; | |
"ISBLANK,value;v,v"; | |
"ISERR,value;v,v"; | |
"ISERROR,value;v,v"; | |
"ISEVEN,number;v,vr"; | |
"ISFORMULA,reference;a,r"; | |
"ISLOGICAL,value;v,v"; | |
"ISNA,value;v,v"; | |
"ISNONTEXT,value;v,v"; | |
"ISNUMBER,value;v,v"; | |
"ISODD,number;v,vr"; | |
"ISOMITTED,argument;v,var"; | |
"ISREF,value;v,var"; | |
"ISTEXT,value;v,v"; | |
"N,value;v,vr"; | |
"NA;v"; | |
"SHEET,[value];v,var"; | |
"SHEETS,[reference];v,ar"; | |
"TYPE,value;v,va" | |
}; | |
fnLogical | |
={ | |
"AND,logical1,[logical2],...;v,var,var,var"; | |
"BYCOL,array,[function];a,ar,v"; | |
"BYROW,array,[function];a,ar,v"; | |
"FALSE;v"; | |
"IF,logical_test,[value_if_true],[value_if_false];var,va,var,var"; | |
"IFERROR,value,value_if_error;va,va,var"; | |
"IFNA,value,value_if_na;va,va,var"; | |
"IFS,logical_test1,value_if_true1,...;var,va,var,va,var"; | |
"LAMBDA,parameter_or_calculation,...;var,var,var"; | |
"LET,name1,name_value1,calculation_or_name2,[name_value2],[calculation_or_name3],[…];var,var,var,var,var,var,var"; | |
"MAKEARRAY,rows,columns,function;a,v,v,var"; | |
"MAP,array,lambda_or_array2,...;ar,var,var"; | |
"NOT,logical;v,v"; | |
"OR,logical1,[logical2],...;v,var,var,var"; | |
"REDUCE,initial_value,array,function;var,var,ar,v"; | |
"SCAN,initial_value,array,function;a,var,ar,v"; | |
"SWITCH,expression,value1,result1,[default or value2],[result2],...;var,va,va,var,var,var,var"; | |
"TRUE;v"; | |
"XOR,logical1,[logical2],...;v,var,var,var" | |
}; | |
fnLookupReference | |
={ | |
"ADDRESS,row_num,column_num,[abs_num],[a1],[sheet_text];v,v,v,v,v,v"; | |
"AREAS,reference;v,r"; | |
"CHOOSE,index_num,value1,[value2],...;var,va,var,var,var"; | |
"CHOOSECOLS,array,col_num1,[col_num2],...;a,ar,v,v"; | |
"CHOOSEROWS,array,col_num1,[col_num2],...;a,ar,v,v"; | |
"COLUMN,[reference];va,r"; | |
"COLUMNS,array;v,ar"; | |
"DROP,array,rows,[columns];var,ar,v,v"; | |
"EXPAND,array,rows,[columns],[pad_with];a,a,v,v,va"; | |
"FIELDVALUE(value,field_name);va,v,v"; | |
"FILTER,array,include,[if_empty];a,ar,ar,va"; | |
"FORMULATEXT,reference;a,r"; | |
"GETPIVOTDATA,data_field,pivot_table,[field1],[item1],field2,item2;v,vr,vr,v,v,v,v"; | |
"HLOOKUP,lookup_value,table_array,row_index_num,[range_lookup];va,v,var,var,v"; | |
"HSTACK,array1,[array2],...;a,ar,ar,ar"; | |
"HYPERLINK,link_location,[friendly_name];va,v,va"; | |
"IMAGE,source,[alt_text],[sizing],[height],[width];v,v,v,v,v,v"; | |
"INDEX,reference|array,row_num,[column_num],[area_num];var,ar,v,v,v"; | |
"INDIRECT,ref_text,[a1];r,v,v"; | |
"LOOKUP,lookup_value,lookup_vector|array,[result_vector];v,v,ar,ar"; | |
"MATCH,lookup_value,lookup_array,[match_type];v,v,var,vr"; | |
"OFFSET,reference,rows,cols,[height],[width];r,r,v,v,v,v"; | |
"ROW,[reference];va,r"; | |
"ROWS,array;v,ar"; | |
"RTD,progID,server,topic1,[topic2],...;v,v,v,v,v,v"; | |
"SORT,array,[sort_index],[sort_order],[by_col];a,a,a,a,v"; | |
"SORTBY,array,by_array1,sort_order1,[by_array2],[sort_order2],...;a,a,a,v,a,v,a"; | |
"TAKE,array,rows,columns;var,ar,v,v"; | |
"TOCOL,array,[ignore],[scan_by_column];a,ar,v,v"; | |
"TOROW,array,[ignore],[scan_by_column];a,ar,v,v"; | |
"TRANSPOSE,array;a,va"; | |
"UNIQUE,array,[by_col],[exactly_once];a,a,v,v"; | |
"VLOOKUP,lookup_value,table_array,col_index_num,[range_lookup];va,v,var,var,v"; | |
"VSTACK,array1,[array2],...;a,ar,ar,ar"; | |
"WRAPCOLS,vector,wrap_count,[pad_with];a,a,v,v"; | |
"WRAPROWS,vector,wrap_count,[pad_with];a,a,v,v"; | |
"XLOOKUP,lookup_value,lookup_array,return_array,[if_not_found],[match_mode],[search_mode];var,v,ar,ar,var,v,v"; | |
"XMATCH,lookup_value,lookup_array,[match_mode],[search_mode];v,v,ar,v,v" | |
}; | |
fnMathTrig | |
={ | |
"ABS,number;v,v"; | |
"ACOS,number;v,v"; | |
"ACOSH,number;v,v"; | |
"ACOT,number;v,v"; | |
"ACOTH,number;v,v"; | |
"AGGREGATE,function_num,options,array|ref1,[k|ref2],[ref3],...;v,v,v,ar,vr,r,r"; | |
"ARABIC,text;v,v"; | |
"ASIN,number;v,v"; | |
"ASINH,number;v,v"; | |
"ATAN,number;v,v"; | |
"ATAN2,x_num,y_num;v,v,v"; | |
"ATANH,number;v,v"; | |
"BASE,number,radix,[min_length];v,v,v,v"; | |
"CEILING.MATH,number,[significance],[mode];v,v,v,v"; | |
"CEILING.PRECISE,number,[significance];v,v,v"; | |
"COMBIN,number,number_chosen;v,v,v"; | |
"COMBINA,number,number_chosen;v,v,v"; | |
"COS,number;v,v"; | |
"COSH,number;v,v"; | |
"COT,number;v,v"; | |
"COTH,number;v,v"; | |
"CSC,number;v,v"; | |
"CSCH,number;v,v"; | |
"DECIMAL,number,radix;v,v,v"; | |
"DEGREES,angle;v,v"; | |
"EVEN,number;v,v"; | |
"EXP,number;v,v"; | |
"FACT,number;v,v"; | |
"FACTDOUBLE,number;v,vr"; | |
"FLOOR.MATH,number,[significance],[mode];v,v,v,v"; | |
"FLOOR.PRECISE,number,[significance];v,v,v"; | |
"GCD,number1,[number2],...;v,var,var,var"; | |
"INT,number;v,v"; | |
"ISO.CEILING,number,[significance];v,v,v"; | |
"LCM,number1,[number2],...;v,var,var,var"; | |
"LN,number;v,v"; | |
"LOG,number,[base];v,v,v"; | |
"LOG10,number;v,v"; | |
"MDETERM,array;v,a"; | |
"MINVERSE,array;a,a"; | |
"MMULT,array1,array2;a,a,a"; | |
"MOD,number,divisor;v,v,v"; | |
"MROUND,number,multiple;v,vr,vr"; | |
"MULTINOMIAL,number1,[number2],...;v,var,var,var"; | |
"MUNIT,dimension;a,v"; | |
"ODD,number;v,v"; | |
"PI;v"; | |
"POWER,number,power;v,v,v"; | |
"PRODUCT,number1,[number2],...;v,var,var,var"; | |
"QUOTIENT,numerator,denominator;v,vr,vr"; | |
"RADIANS,angle;v,v"; | |
"RAND;v"; | |
"RANDARRAY,[rows],[columns],[min],[max],[integer];a,v,v,v,v,v"; | |
"RANDBETWEEN,bottom,top;v,vr,vr"; | |
"ROMAN,number,[form];v,v,v"; | |
"ROUND,number,num_digits;v,v,v"; | |
"ROUNDDOWN,number,num_digits;v,v,v"; | |
"ROUNDUP,number,num_digits;v,v,v"; | |
"SEC,number;v,v"; | |
"SECH,number;v,v"; | |
"SEQUENCE,rows,[columns],[start],[step];a,v,v,v,v"; | |
"SERIESSUM,x,n,m,coefficients;v,vr,vr,vr,var"; | |
"SIGN,number;v,v"; | |
"SIN,number;v,v"; | |
"SINH,number;v,v"; | |
"SQRT,number;v,v"; | |
"SQRTPI,number;v,vr"; | |
"SUBTOTAL,function_num,ref1,...;v,v,r,r"; | |
"SUM,number1,[number2],...;v,var,var,var"; | |
"SUMIF,range,criteria,[sum_range];v,r,v,r"; | |
"SUMIFS,sum_range,criteria_range,criteria,...;v,r,r,v,r,v"; | |
"SUMPRODUCT,array1,[array2],[array3],...;v,a,a,a,a"; | |
"SUMSQ,number1,[number2],...;v,var,var,var"; | |
"SUMX2MY2,array_x,array_y;v,a,a"; | |
"SUMX2PY2,array_x,array_y;v,a,a"; | |
"SUMXMY2,array_x,array_y;v,a,a"; | |
"TAN,number;v,v"; | |
"TANH,number;v,v"; | |
"TRUNC,number,[num_digits];v,v,v" | |
}; | |
fnStatistical | |
={ | |
"AVEDEV,number1,[number2],...;v,var,var,var"; | |
"AVERAGE,number1,[number2],...;v,var,var,var"; | |
"AVERAGEA,value1,[value2],...;v,var,var,var"; | |
"AVERAGEIF,range,criteria,[average_range];v,r,v,r"; | |
"AVERAGEIFS,average_range,criteria_range,criteria,...;v,r,r,v,r,v"; | |
"BETA.DIST,x,alpha,beta,cumulative,[A],[B];v,v,v,v,v,v"; | |
"BETA.INV,probability,alpha,beta,[A],[B];v,v,v,v,v,v"; | |
"BINOM.DIST,number_s,trials,probability_s,cumulative;v,v,v,v,v"; | |
"BINOM.DIST.RANGE,trials,probability_s,number_s,[number_s2];v,v,v,v,v"; | |
"BINOM.INV,trials,probability_s,alpha;v,v,v,v"; | |
"CHISQ.DIST,x,deg_freedom,cumulative;v,v,v"; | |
"CHISQ.DIST.RT,x,deg_freedom;v,v,v"; | |
"CHISQ.INV,probability,deg_freedom;v,v,v"; | |
"CHISQ.INV.RT,probability,deg_freedom;v,a,a"; | |
"CHISQ.TEST,actual_range,expected_range;v,a,a"; | |
"CONFIDENCE.NORM,alpha,standard_dev,size;v,v,v,v"; | |
"CONFIDENCE.T,alpha,standard_dev,size;v,v,v,v"; | |
"CORREL,array1,array2;v,a,a"; | |
"COUNT,value1,[value2],...;v,var,var,var"; | |
"COUNTA,value1,[value2],...;v,var,var,var"; | |
"COUNTBLANK,range;v,r"; | |
"COUNTIF,range,criteria;v,r,v"; | |
"COUNTIFS,criteria_range,criteria,...;v,r,v,r,v"; | |
"COVARIANCE.P,array1,array2;v,a,a"; | |
"COVARIANCE.S,array1,array2;v,a,a"; | |
"DEVSQ,number1,[number2],...;v,var,var,var"; | |
"EXPON.DIST,x,lambda,cumulative;v,v,v,v"; | |
"F.DIST,x,deg_freedom1,deg_freedom2,cumulative;v,v,v,v,v"; | |
"F.DIST.RT,x,deg_freedom1,deg_freedom2;v,v,v,v"; | |
"F.INV,probability,deg_freedom1,deg_freedom2;v,v,v,v"; | |
"F.INV.RT,probability,deg_freedom1,deg_freedom2;v,v,v,v"; | |
"F.TEST,array1,array2;v,a,a"; | |
"FISHER,x;v,v"; | |
"FISHERINV,y;v,v"; | |
"FORECAST.ETS,target_date,values,timeline,[seasonality],[data_completion],[aggregation];v,v,ar,ar,v,v,v"; | |
"FORECAST.ETS.CONFINT,target_date,values,timeline,[confidence_level],[seasonality],[data_completion],[aggregation];v,v,ar,ar,v,v,v,v"; | |
"FORECAST.ETS.SEASONALITY,values,timeline,[data_completion],[aggregation];v,ar,ar,v,v"; | |
"FORECAST.ETS.STAT,values,timeline,statistic_type,[seasonality],[data_completion],[aggregation];v,ar,ar,v,v,v,v"; | |
"FORECAST.LINEAR,x,known_ys,known_xs;v,v,a,a"; | |
"FREQUENCY,data_array,bins_array;a,ar,ar"; | |
"GAMMA,x;v,v"; | |
"GAMMA.DIST,x,alpha,beta,cumulative;v,v,v,v,v"; | |
"GAMMA.INV,probability,alpha,beta;v,v,v,v,v"; | |
"GAMMALN,x;v,v"; | |
"GAMMALN.PRECISE,x;v,v"; | |
"GAUSS,x;v,v"; | |
"GEOMEAN,number1,[number2],...;v,var,var,var"; | |
"GROWTH,known_y's,[known_x's],[new_x's],[const];a,ar,ar,ar,vr"; | |
"HARMEAN,number1,[number2],...;v,var,var,var"; | |
"HYPGEOM.DIST,sample_s,number_sample,population_s,number_pop,cumulative;v,v,v,v,v,v"; | |
"INTERCEPT,known_y's,known_x's;v,a,a"; | |
"KURT,number1,[number2],...;v,var,var,var"; | |
"LARGE,array,k;v,var,v"; | |
"LINEST,known_y's,[known_x's],[const],[stats];a,ar,ar,vr,vr"; | |
"LOGEST,known_y's,[known_x's],[const],[stats];a,ar,ar,vr,vr"; | |
"LOGNORM.DIST,x,mean,standard_dev,cumulative;v,v,v,v,v"; | |
"LOGNORM.INV,probability,mean,standard_dev;v,v,v,v"; | |
"MAX,number1,[number2],...;v,var,var,var"; | |
"MAXA,value1,[value2],...;v,var,var,var"; | |
"MAXIFS,max_range,criteria_range1,criteria1,...;v,r,r,v,r,v"; | |
"MEDIAN,number1,[number2],...;v,var,var,var"; | |
"MIN,number1,[number2],...;v,var,var,var"; | |
"MINA,value1,[value2],...;v,var,var,var"; | |
"MINIFS,min_range,criteria_range1,criteria1,...;v,r,r,v,r,v"; | |
"MODE.MULT,number1,[number2],...;v,a,a,a"; | |
"MODE.SNGL,number1,[number2],...;v,a,a,a"; | |
"NEGBINOM.DIST,number_f,number_s,probability_s,cumulative;v,v,v,v,v"; | |
"NORM.DIST,x,mean,standard_dev,cumulative;v,v,v,v,v"; | |
"NORM.INV,probability,mean,standard_dev;v,v,v,v"; | |
"NORM.S.DIST,z,cumulative;v,v,v"; | |
"NORM.S.INV,probability;v,v"; | |
"PEARSON,array1,array2;v,a,a"; | |
"PERCENTILE.EXC,array,k;v,var,v"; | |
"PERCENTILE.INC,array,k;v,var,v"; | |
"PERCENTRANK.EXC,array,x,[significance];v,var,v,v"; | |
"PERCENTRANK.INC,array,x,[significance];v,var,v,v"; | |
"PERMUT,number,number_chosen;v,v,v"; | |
"PERMUTATIONA,number,number_chosen;v,v,v"; | |
"PHI,x;v,v"; | |
"POISSON.DIST,x,mean,cumulative;v,v,v,v"; | |
"PROB,x_range,prob_range,lower_limit,[upper_limit];v,a,a,v,v"; | |
"QUARTILE.EXC,array,quart;v,var,v"; | |
"QUARTILE.INC,array,quart;v,var,v"; | |
"RANK.AVG,number,ref,[order];v,v,r,v"; | |
"RANK.EQ,number,ref,[order];v,v,r,v"; | |
"RSQ,known_y's,known_x's;v,a,a"; | |
"SKEW,number1,[number2],...;v,var,var,var"; | |
"SKEW.P,number1,[number2],...;v,var,var,var"; | |
"SLOPE,known_y's,known_x's;v,a,a"; | |
"SMALL,array,k;v,var,v"; | |
"STANDARDIZE,x,mean,standard_dev;v,v,v,v"; | |
"STDEV.P,number1,[number2],...;v,var,var,var"; | |
"STDEV.S,number1,[number2],...;v,var,var,var"; | |
"STDEVA,value1,[value2],...;v,var,var,var"; | |
"STDEVPA,value1,[value2],...;v,var,var,var"; | |
"STEYX,known_y's,known_x's;v,a,a"; | |
"T.DIST,x,deg_freedom,cumulative;v,v,v,v"; | |
"T.DIST.2T,x,deg_freedom;v,v,v"; | |
"T.DIST.RT,x,deg_freedom;v,v,v"; | |
"T.INV,probability,deg_freedom;v,v,v"; | |
"T.INV.2T,probability,deg_freedom;v,v,v"; | |
"T.TEST,array1,array2,tails,type;v,a,a,v,v"; | |
"TREND,known_y's,[known_x's],[new_x's],[const];a,ar,ar,ar,vr"; | |
"TRIMMEAN,array,percent;v,var,v"; | |
"VAR.P,number1,[number2],...;v,var,var,var"; | |
"VAR.S,number1,[number2],...;v,var,var,var"; | |
"VARA,value1,[value2],...;v,var,var,var"; | |
"VARPA,value1,[value2],...;v,var,var,var"; | |
"WEIBULL.DIST,x,alpha,beta,cumulative;v,v,v,v,v"; | |
"Z.TEST,array,x,[sigma];v,var,v,v" | |
}; | |
fnText | |
={ | |
"ARRAYTOTEXT,array,[format];va,a,v"; | |
"ASC,text;v,v"; | |
"BAHTTEXT,number;v,v"; | |
"CHAR,number;v,v"; | |
"CLEAN,text;v,v"; | |
"CODE,text;v,v"; | |
"CONCAT,text1,[[text2]],...;v,var,var,var"; | |
"DBCS,text;v,v"; | |
"DOLLAR,number,[decimals];v,v,v"; | |
"EXACT,text1,text2;v,v,v"; | |
"FIND,find_text,within_text,[start_num];v,v,v,v"; | |
"FINDB,find_text,within_text,[start_num];v,v,v,v"; | |
"FIXED,number,[decimals],[no_commas];v,v,v,v"; | |
"LEFT,text,[num_chars];v,v,v"; | |
"LEFTB,text,[num_chars];v,v,v"; | |
"LEN,text;v,v"; | |
"LENB,text;v,v"; | |
"LOWER,text;v,v"; | |
"MID,text,start_num,num_chars;v,v,v,v"; | |
"MIDB,text,start_num,num_chars;v,v,v,v"; | |
"NUMBERVALUE,text,[decimal_separator],[group_separator];v,v,v,v"; | |
"PHONETIC,reference;v,r"; | |
"PROPER,text;v,v"; | |
"REPLACE,old_text,start_num,num_chars,new_text;v,v,v,v,v"; | |
"REPLACEB,old_text,start_num,num_chars,new_text;v,v,v,v,v"; | |
"REPT,text,number_times;v,v,v"; | |
"RIGHT,text,[num_chars];v,v,v"; | |
"RIGHTB,text,[num_chars];v,v,v"; | |
"SEARCH,find_text,within_text,[start_num];v,v,v,v"; | |
"SEARCHB,find_text,within_text,[start_num];v,v,v,v"; | |
"SUBSTITUTE,text,old_text,new_text,[instance_num];v,v,v,v,v"; | |
"T,value;v,vr"; | |
"TEXT,value,format_text;v,v,v"; | |
"TEXTAFTER,text,delimiter,instance_num,match_mode,match_end,if_not_found;v,v,va,v,v,v,v"; | |
"TEXTBEFORE,text,delimiter,instance_num,match_mode,match_end,if_not_found;v,v,va,v,v,v,v"; | |
"TEXTJOIN,delimiter,ignore_empty,text1,...;v,var,v,var,var"; | |
"TEXTSPLIT,text,col_delimiter,row_delimiter,ignore_empty,match_mode,pad_with;a,v,va,va,v,v,va"; | |
"TRIM,text;v,v"; | |
"UNICHAR,number;v,v"; | |
"UNICODE,text;v,v"; | |
"UPPER,text;v,v"; | |
"VALUE,text;v,v"; | |
"VALUETOTEXT,value,[format];v,v,v" | |
}; | |
fnWeb | |
={ | |
"ENCODEURL,text;v,v"; | |
"FILTERXML,xml,xpath;va,v,v"; | |
"WEBSERVICE,url;v,v" | |
}; | |
fnMisc | |
={ | |
"ANCHORARRAY,range;r,r"; | |
"DATESTRING,arg1;v,v"; | |
"ECMA.CEILING,number,significance;v,v,v"; | |
"ISTHAIDIGIT,text;v,v"; | |
"NUMBERSTRING,arg1,arg2;v,v,v"; | |
"ROUNDBAHTDOWN,number;v,v"; | |
"ROUNDBAHTUP,number;v,v"; | |
"SINGLE,value;vr,var"; | |
"THAIDAYOFWEEK,number;v,v"; | |
"THAIDIGIT,number;v,v"; | |
"THAIMONTHOFYEAR,number;v,v"; | |
"THAINUMSOUND,number;v,v"; | |
"THAINUMSTRING,number;v,v"; | |
"THAISTRINGLENGTH,text;v,v"; | |
"THAIYEAR,number;v,v" | |
}; | |
fnMacro | |
={ | |
"A1.R1C1"; "ABSREF"; "ACTIVATE"; "ACTIVATE.NEXT"; "ACTIVATE.NOTES"; | |
"ACTIVATE.PREV"; "ACTIVE.CELL"; "ACTIVE.CELL.FONT"; "ADD.ARROW"; "ADD.BAR"; | |
"ADD.CHART.AUTOFORMAT"; "ADD.COMMAND"; "ADD.LIST.ITEM"; "ADD.MENU"; "ADD.OVERLAY"; | |
"ADD.PRINT.AREA"; "ADD.TOOL"; "ADD.TOOLBAR"; "ADDIN.MANAGER"; "ALERT"; | |
"ALIGNMENT"; "APP.ACTIVATE"; "APP.ACTIVATE.MICROSOFT"; "APP.MAXIMIZE"; "APP.MINIMIZE"; | |
"APP.MOVE"; "APP.RESTORE"; "APP.SIZE"; "APP.TITLE"; "APPLY.NAMES"; | |
"APPLY.STYLE"; "ARGUMENT"; "ARRANGE.ALL"; "ASSIGN.TO.OBJECT"; "ASSIGN.TO.TOOL"; | |
"ATTACH.TEXT"; "ATTACH.TOOLBARS"; "ATTRIBUTES"; "AUTO.OUTLINE"; "AUTOCORRECT"; | |
"AXES"; "BEEP"; "BORDER"; "BREAK"; "BRING.TO.FRONT"; | |
"CALCULATE.DOCUMENT"; "CALCULATE.NOW"; "CALCULATION"; "CALL"; "CALLER"; | |
"CANCEL.COPY"; "CANCEL.KEY"; "CELL.PROTECTION"; "CHANGE.LINK"; "CHART.ADD.DATA"; | |
"CHART.TREND"; "CHART.WIZARD"; "CHECK.COMMAND"; "CHECKBOX.PROPERTIES"; "CLEAR"; | |
"CLEAR.OUTLINE"; "CLEAR.PRINT.AREA"; "CLEAR.ROUTING.SLIP"; "CLOSE"; "CLOSE.ALL"; | |
"COLOR.PALETTE"; "COLUMN.WIDTH"; "COMBINATION"; "CONSOLIDATE"; "CONSTRAIN.NUMERIC"; | |
"COPY"; "COPY.CHART"; "COPY.PICTURE"; "COPY.TOOL"; "CREATE.NAMES"; | |
"CREATE.OBJECT"; "CREATE.PUBLISHER"; "CUSTOM.REPEAT"; "CUSTOM.UNDO"; "CUSTOMIZE.TOOLBAR"; | |
"CUT"; "DATA.DELETE"; "DATA.FIND"; "DATA.FIND.NEXT"; "DATA.FIND.PREV"; | |
"DATA.FORM"; "DATA.LABEL"; "DATA.SERIES"; "DEFINE.NAME"; "DEFINE.STYLE"; | |
"DELETE.ARROW"; "DELETE.BAR"; "DELETE.CHART.AUTOFORMAT"; "DELETE.COMMAND"; "DELETE.FORMAT"; | |
"DELETE.MENU"; "DELETE.NAME"; "DELETE.NOTE"; "DELETE.OVERLAY"; "DELETE.STYLE"; | |
"DELETE.TOOL"; "DELETE.TOOLBAR"; "DEMOTE"; "DEREF"; "DIALOG.BOX"; | |
"DIRECTORY"; "DISABLE.INPUT"; "DISPLAY"; "DOCUMENTS"; "DUPLICATE"; | |
"ECHO"; "EDIT.COLOR"; "EDIT.DELETE"; "EDIT.OBJECT"; "EDIT.REPEAT"; | |
"EDIT.SERIES"; "EDIT.TOOL"; "EDITBOX.PROPERTIES"; "EDITION.OPTIONS"; "ELSE"; | |
"ELSE.IF"; "ENABLE.COMMAND"; "ENABLE.OBJECT"; "ENABLE.TIPWIZARD"; "ENABLE.TOOL"; | |
"END.IF"; "ENTER.DATA"; "ERROR"; "ERRORBAR.X"; "ERRORBAR.Y"; | |
"EVALUATE"; "EXEC"; "EXECUTE"; "EXTEND.POLYGON"; "EXTRACT"; | |
"FCLOSE"; "FILE.CLOSE"; "FILE.DELETE"; "FILES"; "FILL.AUTO"; | |
"FILL.DOWN"; "FILL.GROUP"; "FILL.LEFT"; "FILL.RIGHT"; "FILL.UP"; | |
"FILL.WORKGROUP"; "FILTER"; "FILTER.ADVANCED"; "FILTER.SHOW.ALL"; "FIND.FILE"; | |
"FONT"; "FONT.PROPERTIES"; "FOPEN"; "FOR"; "FOR.CELL"; | |
"FORMAT.AUTO"; "FORMAT.CHART"; "FORMAT.CHARTTYPE"; "FORMAT.FONT"; "FORMAT.LEGEND"; | |
"FORMAT.MAIN"; "FORMAT.MOVE"; "FORMAT.NUMBER"; "FORMAT.OVERLAY"; "FORMAT.SHAPE"; | |
"FORMAT.SIZE"; "FORMAT.TEXT"; "FORMULA"; "FORMULA.ARRAY"; "FORMULA.CONVERT"; | |
"FORMULA.FILL"; "FORMULA.FIND"; "FORMULA.FIND.NEXT"; "FORMULA.FIND.PREV"; "FORMULA.GOTO"; | |
"FORMULA.REPLACE"; "FPOS"; "FREAD"; "FREADLN"; "FREEZE.PANES"; | |
"FSIZE"; "FULL"; "FULL.SCREEN"; "FUNCTION.WIZARD"; "FWRITE"; | |
"FWRITELN"; "GALLERY.3D.AREA"; "GALLERY.3D.BAR"; "GALLERY.3D.COLUMN"; "GALLERY.3D.LINE"; | |
"GALLERY.3D.PIE"; "GALLERY.3D.SURFACE"; "GALLERY.AREA"; "GALLERY.BAR"; "GALLERY.COLUMN"; | |
"GALLERY.CUSTOM"; "GALLERY.DOUGHNUT"; "GALLERY.LINE"; "GALLERY.PIE"; "GALLERY.RADAR"; | |
"GALLERY.SCATTER"; "GET.BAR"; "GET.CELL"; "GET.CHART.ITEM"; "GET.DEF"; | |
"GET.DOCUMENT"; "GET.FORMULA"; "GET.LINK.INFO"; "GET.MOVIE"; "GET.NAME"; | |
"GET.NOTE"; "GET.OBJECT"; "GET.PIVOT.FIELD"; "GET.PIVOT.ITEM"; "GET.PIVOT.TABLE"; | |
"GET.TOOL"; "GET.TOOLBAR"; "GET.WINDOW"; "GET.WORKBOOK"; "GET.WORKSPACE"; | |
"GOAL.SEEK"; "GOTO"; "GRIDLINES"; "GROUP"; "HALT"; | |
"HELP"; "HIDE"; "HIDE.DIALOG"; "HIDE.OBJECT"; "HIDEALL.INKANNOTS"; | |
"HIDEALL.NOTES"; "HIDECURR.NOTE"; "HLINE"; "HPAGE"; "HSCROLL"; | |
"IF"; "INITIATE"; "INPUT"; "INSERT"; "INSERT.MAP.OBJECT"; | |
"INSERT.OBJECT"; "INSERT.PICTURE"; "INSERT.TITLE"; "INSERTDATATABLE"; "JUSTIFY"; | |
"LABEL.PROPERTIES"; "LAST.ERROR"; "LAYOUT"; "LEGEND"; "LINE.PRINT"; | |
"LINK.COMBO"; "LINK.FORMAT"; "LINKS"; "LIST.NAMES"; "LISTBOX.PROPERTIES"; | |
"MACRO.OPTIONS"; "MAIL.ADD.MAILER"; "MAIL.DELETE.MAILER"; "MAIL.EDIT.MAILER"; "MAIL.FORWARD"; | |
"MAIL.LOGOFF"; "MAIL.LOGON"; "MAIL.NEXT.LETTER"; "MAIL.REPLY"; "MAIL.REPLY.ALL"; | |
"MAIL.SEND.MAILER"; "MAIN.CHART"; "MAIN.CHART.TYPE"; "MENU.EDITOR"; "MERGE.STYLES"; | |
"MESSAGE"; "MOVE"; "MOVE.BRK"; "MOVE.TOOL"; "MOVIE.COMMAND"; | |
"NAMES"; "NEW"; "NEW.WINDOW"; "NEWWEBQUERY"; "NEXT"; | |
"NORMAL"; "NOTE"; "OBJECT.PROPERTIES"; "OBJECT.PROTECTION"; "ON.DATA"; | |
"ON.DOUBLECLICK"; "ON.ENTRY"; "ON.KEY"; "ON.RECALC"; "ON.SHEET"; | |
"ON.TIME"; "ON.WINDOW"; "OPEN"; "OPEN.DIALOG"; "OPEN.LINKS"; | |
"OPEN.MAIL"; "OPEN.TEXT"; "OPTIONS.CALCULATION"; "OPTIONS.CHART"; "OPTIONS.EDIT"; | |
"OPTIONS.GENERAL"; "OPTIONS.LISTS.ADD"; "OPTIONS.LISTS.DELETE"; "OPTIONS.LISTS.GET"; "OPTIONS.ME"; | |
"OPTIONS.MENONO"; "OPTIONS.SAVE"; "OPTIONS.SPELL"; "OPTIONS.TRANSITION"; "OPTIONS.VIEW"; | |
"OUTLINE"; "OVERLAY"; "OVERLAY.CHART.TYPE"; "PAGE.SETUP"; "PARSE"; | |
"PASTE"; "PASTE.LINK"; "PASTE.PICTURE"; "PASTE.PICTURE.LINK"; "PASTE.SPECIAL"; | |
"PASTE.TOOL"; "PATTERNS"; "PAUSE"; "PICKLIST"; "PIVOT.ADD.DATA"; | |
"PIVOT.ADD.FIELDS"; "PIVOT.FIELD"; "PIVOT.FIELD.GROUP"; "PIVOT.FIELD.PROPERTIES"; "PIVOT.FIELD.UNGROUP"; | |
"PIVOT.ITEM"; "PIVOT.ITEM.PROPERTIES"; "PIVOT.REFRESH"; "PIVOT.SHOW.PAGES"; "PIVOT.TABLE.CHART"; | |
"PIVOT.TABLE.WIZARD"; "PLACEMENT"; "POKE"; "POST.DOCUMENT"; "PRECISION"; | |
"PREFERRED"; "PRESS.TOOL"; "PRINT"; "PRINT.PREVIEW"; "PRINTER.SETUP"; | |
"PROMOTE"; "PROTECT.DOCUMENT"; "PROTECT.REVISIONS"; "PUSHBUTTON.PROPERTIES"; "QUIT"; | |
"REFTEXT"; "REGISTER"; "REGISTER.ID"; "RELREF"; "REMOVE.LIST.ITEM"; | |
"REMOVE.PAGE.BREAK"; "RENAME.COMMAND"; "RENAME.OBJECT"; "REPLACE.FONT"; "REQUEST"; | |
"RESET.TOOL"; "RESET.TOOLBAR"; "RESTART"; "RESULT"; "RESUME"; | |
"RETURN"; "RM.PRINT.AREA"; "ROUTE.DOCUMENT"; "ROUTING.SLIP"; "ROW.HEIGHT"; | |
"RUN"; "SAVE"; "SAVE.AS"; "SAVE.COPY.AS"; "SAVE.DIALOG"; | |
"SAVE.NEW.OBJECT"; "SAVE.TOOLBAR"; "SAVE.WORKBOOK"; "SAVE.WORKSPACE"; "SCALE"; | |
"SCENARIO.ADD"; "SCENARIO.CELLS"; "SCENARIO.DELETE"; "SCENARIO.EDIT"; "SCENARIO.GET"; | |
"SCENARIO.MERGE"; "SCENARIO.SHOW"; "SCENARIO.SHOW.NEXT"; "SCENARIO.SUMMARY"; "SCROLLBAR.PROPERTIES"; | |
"SELECT"; "SELECT.ALL"; "SELECT.CHART"; "SELECT.END"; "SELECT.LAST.CELL"; | |
"SELECT.LIST.ITEM"; "SELECT.PLOT.AREA"; "SELECT.SPECIAL"; "SELECTION"; "SEND.KEYS"; | |
"SEND.MAIL"; "SEND.TO.BACK"; "SERIES"; "SERIES.AXES"; "SERIES.ORDER"; | |
"SERIES.X"; "SERIES.Y"; "SET.CONTROL.VALUE"; "SET.CRITERIA"; "SET.DATABASE"; | |
"SET.DIALOG.DEFAULT"; "SET.DIALOG.FOCUS"; "SET.EXTRACT"; "SET.LIST.ITEM"; "SET.NAME"; | |
"SET.PAGE.BREAK"; "SET.PREFERRED"; "SET.PRINT.AREA"; "SET.PRINT.TITLES"; "SET.UPDATE.STATUS"; | |
"SET.VALUE"; "SHARE"; "SHARE.NAME"; "SHEET.BACKGROUND"; "SHORT.MENUS"; | |
"SHOW.ACTIVE.CELL"; "SHOW.BAR"; "SHOW.CLIPBOARD"; "SHOW.DETAIL"; "SHOW.DIALOG"; | |
"SHOW.INFO"; "SHOW.LEVELS"; "SHOW.TOOLBAR"; "SIZE"; "SORT"; | |
"SORT.SPECIAL"; "SOUND.NOTE"; "SOUND.PLAY"; "SPELLING"; "SPELLING.CHECK"; | |
"SPLIT"; "STANDARD.FONT"; "STANDARD.WIDTH"; "STEP"; "STYLE"; | |
"SUBSCRIBE.TO"; "SUBTOTAL.CREATE"; "SUBTOTAL.REMOVE"; "SUMMARY.INFO"; "TAB.ORDER"; | |
"TABLE"; "TERMINATE"; "TEXT.BOX"; "TEXT.TO.COLUMNS"; "TEXTREF"; | |
"TRACER.CLEAR"; "TRACER.DISPLAY"; "TRACER.ERROR"; "TRACER.NAVIGATE"; "TRAVERSE.NOTES"; | |
"UNDO"; "UNGROUP"; "UNGROUP.SHEETS"; "UNHIDE"; "UNLOCKED.NEXT"; | |
"UNLOCKED.PREV"; "UNPROTECT.REVISIONS"; "UNREGISTER"; "UPDATE.LINK"; "USDOLLAR"; | |
"VBA.INSERT.FILE"; "VBA.MAKE.ADDIN"; "VBA.PROCEDURE.DEFINITION"; "VBAACTIVATE"; "VIEW.3D"; | |
"VIEW.DEFINE"; "VIEW.DELETE"; "VIEW.GET"; "VIEW.SHOW"; "VLINE"; | |
"VOLATILE"; "VPAGE"; "VSCROLL"; "WAIT"; "WEB.PUBLISH"; | |
"WHILE"; "WINDOW.MAXIMIZE"; "WINDOW.MINIMIZE"; "WINDOW.MOVE"; "WINDOW.RESTORE"; | |
"WINDOW.SIZE"; "WINDOW.TITLE"; "WINDOWS"; "WORKBOOK.ACTIVATE"; "WORKBOOK.ADD"; | |
"WORKBOOK.COPY"; "WORKBOOK.DELETE"; "WORKBOOK.HIDE"; "WORKBOOK.INSERT"; "WORKBOOK.MOVE"; | |
"WORKBOOK.NAME"; "WORKBOOK.NEW"; "WORKBOOK.NEXT"; "WORKBOOK.OPTIONS"; "WORKBOOK.PREV"; | |
"WORKBOOK.PROTECT"; "WORKBOOK.SCROLL"; "WORKBOOK.SELECT"; "WORKBOOK.TAB.SPLIT"; "WORKBOOK.UNHIDE"; | |
"WORKGROUP"; "WORKGROUP.OPTIONS"; "WORKSPACE"; "ZOOM" | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment