jezvanderbrown
New Member
- Joined
- Nov 26, 2013
- Messages
- 11
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
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