Hi,
I'd like some help on a formula if possible. What I want to achieve is where I have a list of names, e.g.
Bob
Fred
Ted
Henry
I then have a table (obviously there would be values associated with these names).
Bob Fred Ted Henry
Product A
Product B
Product C
What I'd like to be able to do is when a new customer name is added to the list - eg add in Harry, I would then like this name to be automatically added into the table headings.
I thought a formula that would lookup all the customer names in the list and if any of the names did not correspond to the table then insert this into the next available column heading.
An example spreadsheet is attached. Please note that I would be unable to change any of the layout of the data apart from the table.
Thanks,
Lea
Bookmarks