如何在班成绩表中统计个人名次表中各班的名次? - 用户社区 - 易表在线答疑 - 简单实用的数据管理软件|数据统计软件|数据分析软件|电子表格软件

参考

下载信息 [文件大小：下载次数： ]
点击浏览该文件:运动会.egd

当前列列名：100_女

colname(1):100

colname(2):女

以下是引用iyplx2425在2015/11/13 8:26:00的发言：
dancedy版主不能帮助解答下6 楼的问题吗？我用EVAL（）函数都试了，无法实现。

IF(FindText("名次总表","第1名_班级","性别", "=" ,"男","比赛项目", "=" ,ColName(1)) = [班级],"√","")

if(Eval("findtext(""个人名次"",""班级1"",""项目"","" = "",""" + ColName(1) + """,""性别"","" = "",""" + ColName(2) + """)") = [班级],"√","")

if(Eval("findtext(""名次总表"",""第" + ColName(3) + "名_班级"",""比赛项目"","" = "",""" + ColName(1) + """,""性别"","" = "",""" + ColName(2) + """)") = [班级],"√","")

以下是引用iyplx2425在2015/11/15 8:36:00的发言：
""第""+""" + ColName(3) + """+""名_班级""，这是一个词分三段表述，""第" + ColName(3) + "名_班级""是一个词就一段表述，本质上应该是一样的啊，为什么效果不一样？是不是易表在设计上存在不足的缘故？

不一样，也不是设计上的问题，是你的公式不对，建议再看看Eval的语法

例如，列名“100m_男_1”

公式：Eval("findtext(""名次总表"",""第" + ColName(3) + "名_班级"",""比赛项目"","" = "",""" + ColName(1) + """,""性别"","" = "",""" + ColName(2) + """)")

原公式为：findtext("名次总表","第1名_班级","比赛项目"," = ","100m","性别"," = ","男")

你的公式：Eval("findtext(""名次总表"",""第""+""" + ColName(3) + """+""名_班级"",""项目"","" = "",""" + ColName(1) + """,""性别"","" = "",""" + ColName(2) + """)")

原公式为：findtext("名次总表","第"+"1"+"名_班级","项目"," = ","100m","性别"," = ","男")

Eval("findtext(""名次总表"", ""第" + ColName(3) + "名_班级"", ""比赛项目"","" = "",""" + ColName(1) + """,""性别"","" = "",""" + ColName(2) + """)")

上面已经完成这个拆分了，重点理解下面这里

"""第" + ColName(3) + "名_班级""" : "第1名_班级"

"""第""+""" + ColName(3) + """+""名_班级""" : "第+1+名_班级"

主题：如何在班成绩表中统计个人名次表中各班的名次?