在常量数组中使用的分隔符列表或选项在公式excel单元格中使用的是什么?
所有样本ex:数组公式中的指南和本节目的帮助; 作为垂直分隔符,作为水平分隔符。 当然,因为我从Windows设置(法语,荷兰语和德语)使用本地化版本的excel似乎只有; 分离器工作
=MATCH("Apr";{"Jan";"Feb";"Mar";"Apr";"May";"Dec"};0)作品(给4)
=VLOOKUP("Apr";{"Jan", "A" ;"Feb", "B";"Apr","D"};2;TRUE)不接受,语法( 您输入的公式包含错误 )并在"Jan",上闪烁"Jan",
我也尝试/看到一些论坛帖子和引用字符串之间的空格字符,但结果相同。 是否有选项可以在excel中指定或替换此分隔符列表?
What is the seperator list or option to use in constant array to use in a formula excel cell ?
all the Sample ex: Guidelines in array formula and help on this show ; as vertical separator and , as horizontal separator. Certainly because i use a localized version for excel from the windows settings (french, dutch and German) it seems that only ; separator works
=MATCH("Apr";{"Jan";"Feb";"Mar";"Apr";"May";"Dec"};0)works (giving 4)
=VLOOKUP("Apr";{"Jan", "A" ;"Feb", "B";"Apr","D"};2;TRUE)does not accept the , syntax (The formula you type contains an error) and blink on "Jan",
I also try / see on some forum post and a space char between the quoted string but with same result. Is there an option to specify in excel or alterantive for this separator list ?
最满意答案
对于法语区域设置,您将使用\(而不是/):
= VLOOKUP( “四月”; { “一月” \ “A”; “二月” \ “B”, “四月” \ “d”}; 2; TRUE)
For French regional settings, you would use \ (not /):
=VLOOKUP("Apr";{"Jan"\"A";"Feb"\"B";"Apr"\"D"};2;TRUE)
更多推荐
发布评论