看這張圖：excel圖像
或查看這個“圖片到文字”範例表：
+--------------------+-----+------------+------------+------------+------------+
| Coolie Ghost | | New Frames | Brown N | Red N | Gray N |
+--------------------+-----+------------+------------+------------+------------+
| Frame 4086 | Yes | Frame 2978 | Frame 3938 | Frame 3366 | Frame 3995 |
+--------------------+-----+------------+------------+------------+------------+
| Sprite number = 86 | No | Frame 2979 | Frame 3328 | Frame 3367 | Frame 3996 |
+--------------------+-----+------------+------------+------------+------------+
| Subnumber = 7 | No | Frame 2980 | Frame 2909 | Frame 4088 | Frame 3997 |
+--------------------+-----+------------+------------+------------+------------+
| Frame 4087 | Yes | Frame 2981 | Frame 3939 | Frame 3369 | Frame 4086 |
+--------------------+-----+------------+------------+------------+------------+
| Sprite number = 87 | No | Frame 2982 | Frame 4087 | Frame 3370 | Frame 3998 |
+--------------------+-----+------------+------------+------------+------------+
| Subnumber = 8 | No | Frame 2983 | Frame 3273 | Frame 3371 | Frame 3999 |
+--------------------+-----+------------+------------+------------+------------+
| Frame 4088 | Yes | Frame 2984 | Frame 3940 | Frame 3381 | Frame 4000 |
+--------------------+-----+------------+------------+------------+------------+
B 列範圍B2:B8有Yes或No值。這是這樣的函數的結果：=IF(COUNTIF($D$2:$F$8;A2);"Yes";"No")。換句話說，如果 A 列資料在D2:F8範圍內重複，則輸出Yes。
我需要的是，而不是它會按從上到下遞增的順序Yes傳回值：等等。透過這樣做，我將知道重複值到底在哪裡以及可以使用哪些可能的非重複值。它將位於相鄰列中的下一個相鄰單元格中。New FramesFrame 2978, Frame 2979, Frame 2980New FramesBA
您還能告訴我如何A2:A8透過自動填入來自動變更實際的重複儲存格值A2嗎？ 而 不是Frame 4086, Frame 4087, Frame 4088in ，而是從上到下A2使用： 等等。
New FramesFrame 2978, Frame 2979, Frame 2980=IF(COUNTIF($D$2:$F$8;A2);C(1+COUNTIF($B$2:B2; $B$2));"")
Cell C(formula)，一個可以選取正確儲存格的公式。可以是C1or 或C2等等C3。單元格座標是對單元格值的引用。所以我的C(將是列，但行數應該由公式計算1+COUNTIF($B$2:B2; $B$2)。但 Excel 不理解這種儲存格分配。也許我不明白如何正確地做到這一點。我想要的結果是這樣的：
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Coolie Ghost | | New Frames | Brown N | Red N | Gray N |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Frame 4086 | Frame 2978 | | Frame 3938 | Frame 3366 | Frame 3995 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Sprite number = 86 | | | Frame 3328 | Frame 3367 | Frame 3996 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Subnumber = 7 | | | Frame 2909 | Frame 4088 | Frame 3997 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Frame 4087 | Frame 2979 | Frame 2981 | Frame 3939 | Frame 3369 | Frame 4086 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Sprite number = 86 | | Frame 2982 | Frame 4087 | Frame 3370 | Frame 3998 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Subnumber = 7 | | Frame 2983 | Frame 3273 | Frame 3371 | Frame 3999 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
| Frame 4088 | Frame 2980 | Frame 2984 | Frame 3940 | Frame 3381 | Frame 4000 |
+--------------------+--------------+--------------+--------------+--------------+--------------+
如何從第一個表實現它？透過使用類似的Excel函數？