I am trying to find a way to have a cell look into a group of other cells and display the first available things it comes to. Then have the next cell look in that same group and display the next item.



cells A1:A5 have 3 pieces of information in them scattered among that column (A1, A3, A5 might have the info in it one day, then A2, A3, A4 the next day)

I want B1:b4 to find the info in the A1:a5 and display it in order as it appears in the A column.

Greatly appreciate all help.