如何在Excel中比较两列？-Java 学习之路

我有这样的excel表：

column1     column2
a            b
b            w
c            a
d            c
e            z
f            k
g            t
h            y
i            j
j            d
k            e
l            f

我想匹配column1的第一个值 a 与column2的每个值 . 如果找到值，我想在下一列中显示一些消息，如 Found 或突出显示值本身，然后在列2中找到值 b ，依此类推 .

Objective:

实际上我在sql中有两个表有多列，这些表也有一些常见的列 . 我只是想找出匹配的列名 . 如果有人还有其他方式，请告诉我 . 提前致谢 .

1 回答

像这样的东西应该在 SQL Server

;with cte as
(
SELECT *
FROM   (VALUES ('a','b'),
               ('b','w'),
               ('c','a'),
               ('d','c'),
               ('e','z'),
               ('f','k'),
               ('g','t'),
               ('h','y'),
               ('i','j'),
               ('j','d'),
               ('k','e'),
               ('l','f') ) tc (column1, column2) 
)
SELECT column1,
       CASE
         WHEN EXISTS (SELECT 1
                      FROM   cte b
                      WHERE  a.column1 = b.column2) THEN 'Found'
         ELSE 'Not Found'
       END AS Identifier
FROM   cte a

Result:

+--------+--------------+
|column1 |  Identifier  |
+--------+--------------+
| a      | Found        |
| b      | Found        |
| c      | Found        |
| d      | Found        |
| e      | Found        |
| f      | Found        |
| g      | Not Found    |
| h      | Not Found    |
| i      | Not Found    |
| j      | Found        |
| k      | Found        |
| l      | Not Found    |
+--------+--------------+

回复于 2024-04-26T12:17:21+08:00

如何在Excel中比较两列？

1 回答

相关问题