- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 240
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-6
|
¦^´_ 1# la1975
AÄæ¸ê®Æ¥²¶·±Æ§Ç
¿ï¨úF1Àx¦s®æªºª¬ºA¤U©w¸q¦WºÙ
x=COUNTIF(¤u§@ªí1!$A$1:$A$4,¤u§@ªí1!$F1)
first=OFFSET(¤u§@ªí1!$B$1,MATCH(¤u§@ªí1!$F1,¤u§@ªí1!$A$1:$A$4,0)-1,,x,)
©w¸q§¹¦¨«á³]¸mF1ÅçÃÒ
²M³æ/¨Ó·½
=$A$2:$A$4
G1ÅçÃÒ
²M³æ/¨Ó·½
=first
H1¤½¦¡
=INDEX(OFFSET(first,,,,2),MATCH($G1,first,0),2)
|
|