Excel - IF Function Problem - Expert Solution

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

Hello, I need help on sorting a rather large list. It is data with people's names and things they purchased. COLUMN A: Items Purchased COLUMN B: FIRST NAME COLUMN C: LAST NAME For every item purchased, is another row even if it's the same person. So: Doll Abbi Sumandal Toy Abbi Sumandal I'm trying to find a way for Excel to recognize duplicates in columns B&C (Abbi Sumandal) and take the unique values and set them in the same row. Final: Abbi Sumandal Doll Toy Is there a formula or function that can do this?!
Solved by V. H. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 25/07/2018 - 04:52
Hello?
Excelchat Expert 25/07/2018 - 04:52
Hi
Excelchat Expert 25/07/2018 - 04:53
Welcome to Got it Pro
User 25/07/2018 - 04:53
How are you. I was wondering if you could help me with a problem i'm having
Excelchat Expert 25/07/2018 - 04:53
Please tell more about the requirement so that i can help you better
User 25/07/2018 - 04:53
I'm trying to figure out how to filter column A based on the information on Columns B & C
User 25/07/2018 - 04:53
So that i can take that data and put it all on one row
User 25/07/2018 - 04:54
I'm not sure if you can see the document preview
Excelchat Expert 25/07/2018 - 04:54
Yes i can see it
Excelchat Expert 25/07/2018 - 04:54
Can you share more data on it so that i can understand better
User 25/07/2018 - 04:54
Sure so i've gotten data from a store
User 25/07/2018 - 04:55
the first column lets say is items purchased but it logged in all of it individually
User 25/07/2018 - 04:55
so there will be a unique row for every item purchased even if it's the same person
User 25/07/2018 - 04:55
how do i consollidate that information so that everything that occurs for the same person repopulates to a single row
User 25/07/2018 - 04:55
of that owner
User 25/07/2018 - 04:58
So like with every occurance of Abbi Sumandal, the items in column A are grouped together
Excelchat Expert 25/07/2018 - 04:58
Yes i understand
Excelchat Expert 25/07/2018 - 04:58
Let me help you out with the formula
Excelchat Expert 25/07/2018 - 05:06
Please have a look on sheet 2
Excelchat Expert 25/07/2018 - 05:06
Let me know if you understand that
User 25/07/2018 - 05:06
no
User 25/07/2018 - 05:06
lol i need to be walked through
User 25/07/2018 - 05:06
sorry
Excelchat Expert 25/07/2018 - 05:07
I just concatenated the filed column B and C
Excelchat Expert 25/07/2018 - 05:07
and against that i am pulling column E which is same as column A
User 25/07/2018 - 05:07
okay
Excelchat Expert 25/07/2018 - 05:08
Let me know if that helps
User 25/07/2018 - 05:08
and did you sort based on column D?
User 25/07/2018 - 05:08
OH there it is
User 25/07/2018 - 05:09
i was like wait lol where's the formula
Excelchat Expert 25/07/2018 - 05:09
Not basis column D, it is fetching value against column D matching it with D13
Excelchat Expert 25/07/2018 - 05:09
Did you understand?
User 25/07/2018 - 05:09
Sort of
Excelchat Expert 25/07/2018 - 05:09
I hope this session is helping you
Excelchat Expert 25/07/2018 - 05:10
Please do give good rating and reviews..it would help a lot
User 25/07/2018 - 05:10
Yeah of course no problem
User 25/07/2018 - 05:10
So... You combined the info from B&C to make column D... and the array forumla goes through that column and any dupes it takes row E and copies it to row 13?
Excelchat Expert 25/07/2018 - 05:11
Yes exactly
User 25/07/2018 - 05:12
oh okay. So if use that formula and there are different ones
User 25/07/2018 - 05:12
Different first last names
Excelchat Expert 25/07/2018 - 05:12
Yes you can
User 25/07/2018 - 05:12
Would i have to use this formula for every unique instance?
User 25/07/2018 - 05:12
Lets say
Excelchat Expert 25/07/2018 - 05:12
combine them like i did and use the same formula
User 25/07/2018 - 05:13
BAH lol can you show me?
User 25/07/2018 - 05:14
is that too much to ask
User 25/07/2018 - 05:14
? hahah i don't mean to be that annoying noob
Excelchat Expert 25/07/2018 - 05:17
See now
User 25/07/2018 - 05:17
Oh okay. Yes I did
User 25/07/2018 - 05:18
Thank you so much! That was super helpful!
User 25/07/2018 - 05:18
I'll be sure to get you a good rating! Thanks!
Excelchat Expert 25/07/2018 - 05:18
Welcome

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.