无码人妻视频在线播放,欧美一线二线三显区别

關(guān)于EXCEL問題？

2023-01-20 23:06投诉举报

如圖，根據(jù)每行上面的數(shù)，返回此數(shù)對應(yīng)列上面的第一行的數(shù)，如果行上面有多個數(shù)，就返回多個。謝謝。

2个回答

匿名用户2023-01-21 02:31

A2輸入
=IF(D2="","",D$1)&IF(E2="","","、"&E$1)&IF(F2="","","、"&F$1)&IF(G2="","","、"&G$1)&IF(H2="","","、"&H$1)&IF(I2="","","、"&I$1)&IF(J2="","","、"&J$1)&IF(K2="","","、"&K$1)&IF(L2="","","、"&L$1)&IF(M2="","","、"&M$1)&IF(N2="","","、"&N$1)&IF(O2="","","、"&O$1)&IF(P2="","","、"&P$1)&IF(Q2="","","、"&Q$1)&IF(R2="","","、"&R$1)&IF(S2="","","、"&S$1)&IF(T2="","","、"&T$1)&IF(U2="","","、"&U$1)&IF(V2="","","、"&V$1)&IF(W2="","","、"&W$1)&IF(X2="","","、"&X$1)&IF(Y2="","","、"&Y$1)&IF(Z2="","","、"&Z$1)&IF(AA2="","","、"&AA$1)&IF(AB2="","","、"&AB$1)&IF(AC2="","","、"&AC$1)&IF(AD2="","","、"&AD$1)

匿名用户2023-01-21 00:08

=IFS(A3<>"",$A$1,B3<>"",$B$1,C3<>"",$C$1,D3<>"",$D$1,TRUE,"")

相关问答

在EXCEL表格中，如何自動更新日期

0个回答2022-11-17 06:17

excel里面小三角怎么做

1个回答2024-08-27 08:20

在excel表格中制作小三角（篩選）的方法如下（以windows10系統(tǒng)的excel2019版為例）： 1、打開excel表格，隨后選中需要制作小三角的數(shù)據(...

全文

excel表如何去重呢？

1个回答2025-03-19 08:50

可以用excel表里的去重功能。 1、以excel2010版本為例，如圖中的一列數(shù)據(jù)是有重復(fù)值的，標紅部分，要去重，那么首先選中該列數(sh...