TEXTJOIN and FILTER functions to concatenate cells that meet certain criteria

Описание к видео TEXTJOIN and FILTER functions to concatenate cells that meet certain criteria

How do you return all cells that meet a certain criteria?
How do you Concatenate the results with a delimiter?

In this video, I show you how to use the TEXTJOIN and FILTER functions to concatenate the results based on certain criteria. As the FILTER function is only available in O365, I also show an alternative approach to that

Workbook can be found here
https://drive.google.com/open?id=1dEu...

#TextJoin #FilterFunction #microsoftExcel

Комментарии

Информация по комментариям в разработке