I tried to write this function in Power Query (Excel hell). Gave up after an hour or so.