Skip to content

Instantly share code, notes, and snippets.

@lhem

lhem/gist:37e252ccd6ae700a12f3091cb16bd64b

Last active August 9, 2023 18:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lhem/37e252ccd6ae700a12f3091cb16bd64b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lhem/37e252ccd6ae700a12f3091cb16bd64b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
// 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