How to make a list table in excel | LAMBDA
=LAMBDA(array,
LET(one,TAKE(array,,1),two,TAKE(array,,-1),
list,UNIQUE(one),
HSTACK(list,BYROW(list,LAMBDA(x,TEXTJOIN(", ",TRUE,FILTER(two,one=x)))))))
These formulas are only available in some versions of excel: https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066
Видео How to make a list table in excel | LAMBDA канала Karina Adcock
LET(one,TAKE(array,,1),two,TAKE(array,,-1),
list,UNIQUE(one),
HSTACK(list,BYROW(list,LAMBDA(x,TEXTJOIN(", ",TRUE,FILTER(two,one=x)))))))
These formulas are only available in some versions of excel: https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066
Видео How to make a list table in excel | LAMBDA канала Karina Adcock
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use measurements from the NOAA website Part 2
Copy Multiple Items in Excel #shorts
How to make a parliament chart in excel
How to use measurements from the NOAA website
How to calculate decimal dates from date and time in excel
TEXTBEFORE in Excel
New Excel Feature - Place Images in Cells
Copy colors from picture and make a custom color palette in excel
Quickly apply the same format to multiple shapes in powerpoint
My YouTube Analytics 2020
How to make a plum pudding chart in excel
Making a diagram in powerpoint
How to use databridge to make NetCDF files
Fill area of chart using matplotlib in python
How to make Tokyo Olympics medal pictogram with flourish
How to link excel spreadsheets together
Average with Errors in Excel #shorts
How to make a calendar heatmap in excel of average number of births
Stop chart moving with cells in Excel
How to animate a chart in powerpoint