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

Показать описание
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))
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))