I have Column A with mixed data types (numbers and strings) and in Column B I want for each numbers in Column A to display the string that is the closest above. Example:
Title| 1|Title 2|Title Next title| 3|Next title etc.
I was able to do it with a formula per row (here in B5 for instance):
But as I have thousands of lines I'm looking for an
=ARRAYFORMULA() solution, if possible.