# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to know How I can get the first name column and last name column and a third column for a speaker they chose to be in the same book? We are using constant contact and the attendance is put for us as 1 individual or 2 attending that session.
Solved by D. B. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/02/2018 - 03:09
Hello.
User 12/02/2018 - 03:09
hello
Excelchat Expert 12/02/2018 - 03:09
Welcome to Excel Chat.
Excelchat Expert 12/02/2018 - 03:09
User 12/02/2018 - 03:09
Excelchat Expert 12/02/2018 - 03:10
Please let me know what you want to get done.
Excelchat Expert 12/02/2018 - 03:10
It would be great if we work with some sample data. Please use the sheet to show some data here.
User 12/02/2018 - 03:11
we are using constant contact in preparation for a conference and I am trying to match the first and last name of the people with the speaker session that they are attending
Excelchat Expert 12/02/2018 - 03:11
ok
Excelchat Expert 12/02/2018 - 03:12
Ok. So what 1 means in column C, D and E
User 12/02/2018 - 03:13
the 1 and 2 signify if it it one individual attending or a couple
Excelchat Expert 12/02/2018 - 03:13
Ok. I got it.
User 12/02/2018 - 03:13
for example julie nd john are a couple wanting to attend the same session
User 12/02/2018 - 03:14
I am trying to get a formula that help me attch a name to the speaker session, so when I print the session... I get all the people attending under the hreading
Excelchat Expert 12/02/2018 - 03:14
And Julie has no relation with the John Keeper in row 4
User 12/02/2018 - 03:15
yes they are a couple... but each is placed i=on a line because in the other 2 sessions as you see each is attending a different session
User 12/02/2018 - 03:15
is it possible ?????
Excelchat Expert 12/02/2018 - 03:15
Ok. But then it would be difficult to know how they are related.
User 12/02/2018 - 03:16
we know it through paypal.....
Excelchat Expert 12/02/2018 - 03:16
Then you have to enter that information first.
Excelchat Expert 12/02/2018 - 03:16
in a separate column.
User 12/02/2018 - 03:16
ok
Excelchat Expert 12/02/2018 - 03:16
But then it would become more of a VBA macro task.
Excelchat Expert 12/02/2018 - 03:17
Anyway give me few moments to think if this can be done through some formula.
User 12/02/2018 - 03:17
excuse my ignorance..
User 12/02/2018 - 03:17
what is that
User 12/02/2018 - 03:17
thank you
Excelchat Expert 12/02/2018 - 03:17
VBA macros are pieces of code supported by Excel to automate tasks.
User 12/02/2018 - 03:18
oh ok
User 12/02/2018 - 03:18
thank you
Excelchat Expert 12/02/2018 - 03:24
Sorry to keep you waiting.
Excelchat Expert 12/02/2018 - 03:24
I am attaching a sample worksheet, which uses Pivot to filter out the attendance lists.
User 12/02/2018 - 03:24
its ok... thank you for trying to help me!
User 12/02/2018 - 03:25
thank you
Excelchat Expert 12/02/2018 - 03:25
Excelchat Expert 12/02/2018 - 03:25
Please see this sheet. But for your use, this doesn't consider the couple yet and you will have to modify the Pivots depending on your data.
User 12/02/2018 - 03:26
User 12/02/2018 - 03:26
Thank you
Excelchat Expert 12/02/2018 - 03:26
This way you can filter out the attendance lists for different speakers.
Excelchat Expert 12/02/2018 - 03:26
User 12/02/2018 - 03:26
bless you heart I really appreciate your help
Excelchat Expert 12/02/2018 - 03:26
Excelchat Expert 12/02/2018 - 03:26
Hope to see you here again soon.
User 12/02/2018 - 03:27
most definitely!!!!
Excelchat Expert 12/02/2018 - 03:27
You can close this session now. Bye! :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.