正在加载视频...

视频加载失败

Lookup & Return Multiple Values in Single Cell in #Excel (NO VBA | Easy Dynamic Array Formula) When the Lookup Values are Duplicates and Needs to Fetch Multiple Outputs | TEXTJOIN in Excel 2019 / 365 =TEXTJOIN(", ",TRUE,IF(A22=Data[Employees],Data[Skills],""))

87,769 次观看 • 3 年前 •via X (Twitter)

2 条评论

SaiKiran Kittu 的头像
SaiKiran Kittu3 年前

Can we use this formula...? =TEXTJOIN(", ",TRUE,FILTER(Data[Skills],Data[Employees]=A22,""))

Ratan Kumar Shukla 的头像
Ratan Kumar Shukla3 年前

@SaveMyVideo

相关视频