[ ίΔΜϋΦ | κ(ΕVXV) | SΆυ | ίO ]
@
wd‘·ιf[^ΕρπWv΅o·ιϋ@xiβάj
A b 1
A b 1
A b 1
A b 2
A b 2
A b 3
B b 1
B b 2
B b 2
ΘΗΜͺ ικΙA
AΜΕ½Ν1ΙΘιΜΕyA@1z
BΜΕ½Ν2ΙΘιΜΕyB@2z
ΘΗΖ\¦·ιΙΝΗΜζ€ΘΦΕoܷš倩B
Β\Ε κΞAyAz(1)¨3ρ,(2)¨2ρ,(3)¨1ρΘΗΜ\¦ͺΕ«ιΖπ΅’Ε·B
½²X΅¨θ’v΅ά·B
gp ExcelFMicrosoft365Agp OSFunknown
__A __B __C __D_ __E___ __F___ __G___ 1 ρ1 ρ2 Κ ~1 ~2 ~3 2 A 1 A 1¨3ρ 2¨2ρ 3¨1ρ 3 A 1 B 2¨2ρ 1¨1ρ 4 A 1 5 A 2 6 A 2 7 A 3 8 B 1 9 B 2 10 B 2
[D2] =UNIQUE(A2:A10) [E2] =IF(D2="","",LET(a,UNIQUE(FILTER($B$2:$B$10,$A$2:$A$10=D2)),b,COUNTIFS($A$2:$A$10,D2,$B$2:$B$10,a),c,SORT(HSTACK(a,b),2,-1),TRANSPOSE(take(c,,1)&"¨"&take(c,,-1)&"ρ")))@«ΙRs[
iάι2021j 2023/10/12(Ψ) 13:29:02
ΕεpxΜvfΎ―Ε’’A©ΒAuρ2vͺlΘη
__A __B __C __D_ __E_____ __F 1 ρ1 ρ2 Κ Εεpx 2 A 1 A 1 2 3 A 1 B 2 4 A 1 5 A 2 6 A 2 7 A 2 8 B 1 9 B 2 10 B 2
[D2] =UNIQUE(A2:A10) [E2] =LET(a,FILTER($B$2:$B$10,$A$2:$A$10=D2),TRANSPOSE(MODE.MULT(a))) «ΙRs[
iάι2021j 2023/10/12(Ψ) 13:37:07
s{bge[uΕΝ_ΘρΕ·©ΛH « ΘWvͺΘPΙΕ«ά·―Η₯₯₯ @ Ϊ1 Ϊ2 Β A 1 3 A 2 2 A 3 1 B 2 2 B 1 1
ΘγAQlάΕ iΞj 2023/10/12(Ψ) 16:09:33
Ϊ1 Ϊ2 Β A 1 3 B 2 2
ipivotj 2023/10/12(Ψ) 18:20:32
[ κ(ΕVXV) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.