excel中,A1到J1是0-9,A2到J2是分别是几个不同大小的数,代表的是A1-J110个数出现的次数

2025-06-28 23:39:07
推荐回答(1个)
回答1:

A3 =INDEX($A$1:$J$1,SUMPRODUCT((($A$2:$J$2+COLUMN($A$2:$J$2)/1000000)=LARGE(($A$2:$J$2+COLUMN($A$2:$J$2)/1000000),COLUMN(A1)))*COLUMN($A$2:$J$2)))CTRL+SHIFT+ENTER(数组公式),向右拉到J3,公式为从大到小排列