Dynamically Extract Data Columns based on String in Excel with CHOOSECOLS & TEXTSPLIT Function

preview_player
Показать описание
Dynamically Extract Data Columns based on String in Excel with CHOOSECOLS & TEXTSPLIT Function | #Excel 365

For Numbers Based Columns Selection
=CHOOSECOLS(Data[#All],--TEXTSPLIT(D4,","))

For Text Based Columns Selection
=LET(
headers, B15:F15,
requestedHeaders, TEXTSPLIT(D4, ", "),
colIndices, MAP(requestedHeaders,
LAMBDA(h, MATCH(h, headers, 0))),
CHOOSECOLS(B15:F21, colIndices))
Рекомендации по теме
visit shbcf.ru