天气预报15天查询> 社会> Excel相同项合并

Excel相同项合并

更新时间: 2021-04-08 03:39:21     

1、在C1单元格输入以下公式,然后向下填充公式 =B1&IF(COUNTIF(A2:A7,A1),""&VLOOKUP(A1,A2:C8,3,0),"")

2、将A列复制到E列,选择E列,在“数据”选项下“删除重复项”;

3、在F列输入以下公式,然后向下填充公式 =VLOOKUP(E1,A:C,3,0)

详见附图:

关键词: excel 相同 合并

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-2520815/ | 耗时:0.2421 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2520815 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2520815 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2520815 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2639497,2520815,1450291,1056209,1047834,2884954,1212919,3255206,724042,548302,3249734,3309758,2016614,3335185,1648962,3159341,627362,1002553,457585,3111060,2962951,2867814,3250484,387983,3450701,3440705,1899442,2488872,3200130,1152336) ORDER BY field (ArticleID,2639497,2520815,1450291,1056209,1047834,2884954,1212919,3255206,724042,548302,3249734,3309758,2016614,3335185,1648962,3159341,627362,1002553,457585,3111060,2962951,2867814,3250484,387983,3450701,3440705,1899442,2488872,3200130,1152336)