Excel - Insert values, ignoring blank cells formula

[jezvanderbrown]

Hi,


I've been racking my brains trying to think of a formula that would do what i require but I'm unsure what it would be, its probably something simple but hopefully somebody can help.

Looking at the above I can't think of a formula to place into cell B2 that will search column A and insert the first result it comes to (ignoring the blank cells).
Then in Cell B2 a formula that will insert the 2nd result and so forth. Is this possible or something similar?


Thanks in advance

 

[deciog]

jezvanderbrown


Checks if this is how you wish

Link https://www.sendspace.com/file/k2teo6


Decio