Excel涓璅ILTER鍑芥暟鎬庝箞浣跨敤
扬州沐宇科技
2023-09-14 12:56:28
excel
鍦‥xcel涓紝FILTER鍑芥暟鍙互鏍规嵁鎸囧畾鐨勬潯浠剁瓫閫夋暟鎹€?/p>
FILTER鍑芥暟鐨勮娉曞涓嬶細
FILTER(array, include, [if_empty])
array锛氳绛涢€夌殑鏁版嵁鑼冨洿銆?/p>
include锛氳鍖呭惈鍦ㄧ瓫閫夌粨鏋滀腑鐨勬潯浠躲€傚彲浠ユ槸涓€涓暟鍊笺€佹枃鏈€侀€昏緫琛ㄨ揪寮忥紝涔熷彲浠ユ槸涓€涓暟缁勩€?/p>
if_empty锛氬彲閫夊弬鏁帮紝琛ㄧず褰撶瓫閫夌粨鏋滀负绌烘椂锛岃繑鍥炵殑鍊笺€?/p>
涓嬮潰鏄竴涓ず渚嬶紝婕旂ず濡備綍浣跨敤FILTER鍑芥暟銆?/p>
鍋囪鏈変互涓嬫暟鎹細
A1锛歂ame
A2锛欽ohn
A3锛欰lice
A4锛欱ob
A5锛歍om
B1锛欰ge
B2锛?5
B3锛?0
B4锛?5
B5锛?0
C1锛欸ender
C2锛歁ale
C3锛欶emale
C4锛歁ale
C5锛歁ale
濡傛灉鎯宠绛涢€夊嚭鈥淕ender鈥濆垪涓€间负鈥淢ale鈥濈殑鎵€鏈夎锛屽彲浠ヤ娇鐢ㄤ互涓嬪叕寮忥細
=FILTER(A2:B5, C2:C5=鈥淢ale鈥?
璇ュ叕寮忕殑缁撴灉灏嗚繑鍥炰互涓嬫暟鎹細
A1锛歂ame
A2锛欽ohn
A3锛欱ob
A4锛歍om
B1锛欰ge
B2锛?5
B3锛?5
B4锛?0
娉ㄦ剰锛屽鏋滅瓫閫夌粨鏋滀负绌猴紝鍙互鍦ㄥ叕寮忎腑浣跨敤绗笁涓弬鏁癷f_empty锛屾寚瀹氳繑鍥炵殑鍊笺€備緥濡傦紝濡傛灉鎯宠鍦ㄧ瓫閫夌粨鏋滀负绌烘椂杩斿洖鈥滄棤鍖归厤鏁版嵁鈥濓紝鍙互浣跨敤浠ヤ笅鍏紡锛?/p>
=FILTER(A2:B5, C2:C5=鈥淔emale鈥? 鈥滄棤鍖归厤鏁版嵁鈥?
