see also docs

make column with unique values from a matrix



lower(REGEXREPLACE(REGEXREPLACE( REGEXREPLACE(REGEXREPLACE(Trefwoorden!C2:C; "[–’+=&?|,\.() ""$/':;]"; "-") ;"-+";"-"); "[^a-zA-Z0-9\-]";"");"^-|-$"; ""))

Vlookup with Search Key in Multiple Column Range (won’t work in Excel)



transpose comma separated values in multiple rows to one long list of items


shortcut for new sheet

Automatische links in spreadsheet kolom voor elke regel

'place this in the header cell above a column, that way you will still be able to sort the sheet