It can be solved by new column with array formula. Like here http://excel-example.com/other-tutor...-array-formula