some might find this useful when op has a different language version of excel
i may have posted this before .
http://en.excel-translator.de/
its easy to use and has a 6 language instruction choice
but translates from/to many more
you can also specify separator as , or ;
eg english to dutch
eg
IFERROR(INDEX($A$13:$J$13,SMALL(IF($A$13:$J$13<=SMALL($A$13:$J$13,5),COLUMN($A$13:$J$13),""),ROW(A1))),"")
becomes
ALS.FOUT(INDEX($A$13:$J$13;KLEINSTE(ALS($A$13:$J$13<=KLEINSTE($A$13:$J$13;5);KOLOM($A$13:$J$13);"");RIJ(A1)));"")
Bookmarks