ExcelBanter - SQL like function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SQL like function? (https://www.excelbanter.com/excel-worksheet-functions/170709-sql-like-function.html)

SQL like function?

In excel, is there any function like

select colA from tableB where colC="a string"

so a new column colD with cells packed together will be generated?

All times are GMT +1. The time now is 12:51 AM.