返回行中每个匹配值的列索引？
Excel 新手在此处使用 Excel for Business（在线）。
我很难思考如何编写一个为我做三件事的函数。
- 检查大型表中的特定数据行，最好是匹配两个表之间的 ID（我一直在使用 XLOOKUP 来确保结果以特定 ID 为键）
- 查找并返回行中每个单元格的列索引字符串“Yes”
- 对与列索引相关的关联点进行求和。
我正在创建一个新的 QA 评分系统，所有问题都可能有“是”和“否”的可能性，但根据问题的不同，分数会有所不同。我一直在接近这个想法，我可以返回列索引，将它们转换为与列索引关联的点，然后对它们求和以获得分数，但我对不同的想法持开放态度。
Excel Novice using Excel for Business (Online) here.
I am having a difficult time wrapping my head around a way to write a function that does three things for me.
- Check a specific row of data in a large table, preferably matching ID's between the two tables (I've been using XLOOKUP to ensure that results are keyed to a specific ID)
- Find and return the Column index for every cell within the row with the string "Yes"
- SUM associated points tied to the column indexes.
I am creating a new QA Scoring system, and all of the questions share the potential for "Yes" and "No" but depending on the question the number of points will be different. I have been approaching this with the idea that I could return the column indexes, convert them to the points associated to the column indexes, and then SUM them for a score, but I am open to different ideas.
Click Here for a Demo of what I am trying to do, included is the actual data set I was using.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
可能的积分
获得的积分
这些将适用于您当前的设置，但从长远来看，如果可能的话，最好将可能的积分和获得的积分列添加到表 3 中。
Possible Points
Points Earned
These will work with your present setup, but in the long run it would probably be best to just add Possible Points and Points Earned columns to your Table3, if possible.