blocks|key|948791|text|这是我第一次回答，所以请轻点:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|948792|我想我理解您正在尝试做什么，并设法找到一个比陷入一个巨大的嵌套查询公式更简单的解决方案。|948793|我创建了一个单独的选项卡，名为Count，并在那里列出了以前添加过的所有产品的唯一ID。然后，在那里添加一个列，显示该产品添加的次数。旁边是另一列，表示该产品被减去了多少次。最后，另一列的余额差额，这是您的剩余股票。|948794|然后，在“结果”选项卡上使用一个简单的查询，该选项卡只显示库存为1或更多的产品。(例句:)|948795|好的，我刚刚意识到我编辑了你的样本表。糟了。哦，公式在新的计数选项卡和结果标签中。|948796|我希望这能帮到你。祝好运!|948797|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

This is my first time answering so be gentle :)
I think I understand what you're trying to do and managed to find a simpler solution than to bog down a giant nested query formula.
I created a separate tab named Count and there you list the Unique ID's of all products that have ever been added before. Then you add a column there for the number of times that product has been added. Next to it another column for how many times that product has been subtracted. Then finally another column for the balance difference, which is your leftover stock.
You then use a simple query on your Results tab which shows only products that have 1 or more in stock. Simples :)
OK I'm just now realizing I edited your sample sheet. Oops. Oh well, the formula's are there for the new Count tab as well as the Results Tab.
I hope this helps. Good luck!

blocks|key|948831|text|用途：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|948832|=FILTER('Add+Log'!A2:D,+NOT(COUNTIF('Subtract+Log'!A2:A,+'Add+Log'!A2:A)))|code-block|syntax|javascript|948833|​|948834|📷|atomic|offset|length|948835|948836|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/7e8f957dbe0429d3c025158bbb2def78.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Z|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|10|8|@]|9|@$L|11|M|12|1|13]]|A|$]]|$1|N|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V|W|-4]]]]

use:
<pre><code>=FILTER('Add Log'!A2:D, NOT(COUNTIF('Subtract Log'!A2:A, 'Add Log'!A2:A)))
</code></pre>
<a href="https://i.stack.imgur.com/iAbE5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iAbE5.png" alt="enter image description here" /></a>

I am trying to keep track of an <code>Add Log</code> and <code>Subtract Log</code> for a list of items and create a list of items still in stock based of of what items have been removed using the <code>Subtract Log</code>. I want the <code>Add/Subtract Log Results</code> to show all items that do not have a matching unique ID (ColA) in the <code>Subtract Log</code> unless a item was returned and added a second, third, forth, etc. Time to the <code>Add Log</code>. If the item is then added to the <code>Subtract Log</code> again it should be removed from the Add/Subtract Log Results sheet
The current formula that I am using is
<code>=UNIQUE({QUERY(QUERY({UNIQUE('Add Log'!$A$2:$D); UNIQUE('Subtract Log'!$A$3:$D)}, &quot;SELECT Col1, Col2, Col3, Col4, COUNT(Col1) WHERE Col1 &lt;&gt; '' AND Col2 &lt;&gt; '' AND Col3 &lt;&gt; '' AND Col4 &lt;&gt; '' GROUP BY Col1, Col2, Col3, Col4&quot;, 0), &quot;SELECT Col1, Col2, Col3, Col4 WHERE Col5 = 1&quot;, 0); QUERY(QUERY('Add Log'!$A$2:$D, &quot;SELECT A, B, C, D, COUNT(A) GROUP BY A, B, C, D&quot;, 0), &quot;SELECT Col1, Col2, Col3, Col4 WHERE Col5 &gt; 1&quot;, 0)})</code>
For some reason if I delete the info in row 11 the formula breaks as well but it seems like if I delete anything else it's fine.
<a href="https://docs.google.com/spreadsheets/d/1d-dS4Bxm4btl5OdASYjrMohBSF7mirmIONwiE0fs3Es/edit?usp=sharing" rel="nofollow noreferrer">Example Sheet</a>
<img src="https://i.stack.imgur.com/4YIjj.png" alt="Example Data-Add Log" />
<img src="https://i.imgur.com/1hGNleo.png" alt="Example Data-Subtract Log" />
<img src="https://i.imgur.com/jPgS9FJ.png" alt="Example Data-Add/Subtract Log Results" />

List all rows that do not have 2 matching unique ids

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我试图跟踪Add Log和Subtract Log中的项目列表，并根据使用Subtract Log删除的项目创建仍然库存的项目列表。我希望Add/Subtract Log Results显示在Subtract Log中没有匹配的唯一ID (ColA)的所有项，除非返回了一个条目并向Add Log添加了第二、第三、第四等...

问列出没有两个匹配的唯一ids的所有行。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问列出没有两个匹配的唯一ids的所有行。EN