这样的公式如何在spread里写

在excel里面使用的frequency函数
=MAX(FREQUENCY(IF(G4:G723=0,ROW(G4:G723)),IF(G4:G723=0,,ROW(G4:G723))))

如何在spread里面写呢

你好，关于公式设置问题，可以参见->公式指南，里面有详细的说明。

公式指南里 没有这样的 复合函数 介绍

请参考：http://gcdn.grapecity.com/showtopic-2669.html

clubfarpoint论坛给出了一个例子
但我的无法调试，只能看见代码

11846838599811.zip (15.02 KB, 下载次数: 532)

2011-11-16 11:10 上传

点击文件名下载附件

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace complexformula
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 2].Formula = "INDEX(FREQUENCY(A1:A10,B1:B4),1,1)";
            fpSpread1.Sheets[0].Cells[1, 2].Formula = "INDEX(FREQUENCY(A1:A10,B1:B4),2,1)";
            fpSpread1.Sheets[0].Cells[2, 2].Formula = "INDEX(FREQUENCY(A1:A10,B1:B4),3,1)";
            fpSpread1.Sheets[0].Cells[3, 2].Formula = "INDEX(FREQUENCY(A1:A10,B1:B4),4,1)";
            fpSpread1.Sheets[0].Cells[4, 2].Formula = "INDEX(FREQUENCY(A1:A10,B1:B4),5,1)";

        }

        private void button2_Click(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[10,0].Formula = "MAX(FREQUENCY(ROW(A1:A10),ROW(B1:B4)))";
        }
    }
}

iceman老师，能帮我弄一下吗？

Hello,

Most of the functions used by you are array functions which are computed in a different way in Excel, however they cannot be computed in the same way in Spread. Spread has same functions which accept array as a parameter and even return an array, however the array returned is not displayed directly in Spread as is the case in Excel. In Spread if you want to display this array you would need to access each element of the Array and display it using the Index function, which is meant to return an element in an array. However in the formula specified by you, you are simply passing the arrays returned by functions as parameters to functions and finally return a single value so this can be done directly using the same formula. But the formula specified by you is not working even in Excel at my end, the issue is with the parameters passed to the Frequency function. So, I just changed these parameters to two cell ranges in the sheet and it made the formula to work in both Excel ads well as Spread. The formula used by me was :

                                                                        =MAX(FREQUENCY(ROW(A1:A10),ROW(B1:B4)))

So, in case you want to return a single value from a formula, you can apply the formula directly as you do in Excel and if you want to return an array then you would need to take the help of the Index function. I am attaching a sample depicting how I used the above formula and the Index function, kindly have a look at the same. Hope it will help you. Please let me know if you have any queries further.

Thanks,

Manpreet KAur.

你好，为什么调试不了呢，错误提示信息是什么？用你本机的 Spread 程序集替换 Demo 中的 Spread 程序集试下。

从信息上看是程序集引用错误，先删除提示中的程序集，再把你本机的 Spread 程序集引用的工程中，在进调试。

png

INDEX(FREQUENCY(A1:A10,B1:B4),1,1)
里面的参数是什么意思呢？