Greetings,

This should be simple, but the solution escapes me.

I have a fixed length column (19 Rows).
In this column I have a list of names, I use a formula to fill in these
cells and the list and order of names will not change, only how many and the
combination of the names that appear.
This list can consist of anywhere from 2 to 16 entries, (most of the time
only 2 to 4 entries), the empty cells can be numbers or blank.

What I need is to return each name that appears in the list individually to
insert into a seperate "index(match" formula to retrieve a value from a table
using the names as column and row coordinates, (which I understand how to do).

I hope I have explained this enough, thanks in advance for your help.