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
How may I help you?
User
12/02/2018 - 03:09
yes please
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
[Uploaded an Excel file]
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
perfect I appreciate your help!
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
I am glad that I could help you.
User
12/02/2018 - 03:26
bless you heart I really appreciate your help
Excelchat Expert
12/02/2018 - 03:26
Thanks for your kind words.
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.