我试图计算 第一和第二 个 Quartile 值, 以计算我在不同工作表上 的一组数值。 我现在使用的公式是
QUARTILE((C15, Week 05-13 to 05-19 !C15, Week 05-06 to 05-12 !C15, week 04-29 to 05-04 !C15), 1)
其中“Week 05-13 to 05-19”、“Week 05-06 to 05-12”和“周4-29 to 05-04”是不同的床单,“C15”指当前工作表中的单元格C15。
当我计算MAX,MIN,和MEDIAN的时候,这效果很好, 但是现在我试图计算QUATILE, 我得到了一个“#value!”错误, 尽管我知道所有数值都是数字, 因为它对MAX,MIN,和MEDIAN都有用。
我觉得我的阵列语法一团糟, 这也是造成我问题的原因, 但我似乎搞不清楚。谢谢任何帮助!
无法在不同工作表上使用多个区域语法。 如果您的工作表是连续的, 您可以尝试输入一个 3D 引用作为第一个参数, 直接在下面输入, 或者在一个工作表上选择一个单元格, 然后选择另一个带换位的制表符 。
=QUARTILE( week 04-29 to 05-04:Week 05-20 to 05-26 !C15, 1)
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...