Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records

[ss1fusion1]

How to insert dynamic dropdwon calender and time.

[ExcelIsFun]

I do not know. Try THE best Excel question site:

mrexcel[dot]com/forum

[eliadrin1]

Thank you for the great tutorials.

I have a question regarding a somewhat similar scenario as this, but instead of eliminating duplicates, I need to group them.

so for example in your table above I want to find Eva& Quad,when there is a match take what ever is in row C (as text) and copy it to one cell,like this: Eva Quad $43,$72,$36, etc.

[ExcelIsFun]

Where does the $43, $72, $36 come from? Or do you mean:

$43, $12, ...

Do you mean all the values in column C that come from the matching records for Eva & Quad?

[eliadrin1]

@ExcelIsFun sorry,

I meant,to look at Eva and consolidate to one or more cell(so I can compare later)

all her sales,as text from the C column.

Thanks,

[ExcelIsFun]

So you want just Eva's, Mike's sales and take them from Column C and place them in a row?

Or are there two criteria, like Eva and Quad, Exa and Carlota, etc?

[ExcelIsFun]

If it is just EVA try these videos:

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

[eliadrin1]

@ExcelIsFun

I just watched these tutorials you recommended and it is kind of what I'm trying to do but not exactly.

in my case I need to make a new work sheet with the same info as the other, only organized as groups.

once again thank you for all your amazing tutorials and all your help.

[ExcelIsFun]

I still am unclear about what you are trying to do. You can send a YouTube e-mail to me and explain your situation in more detail and I will try to help.

[eliadrin1]

@ExcelIsFun

How do I do that(send youtube email), and can I attach an example there?

[ExcelIsFun]

send to excelisfun[at]gmail[dot]com.

[ExcelIsFun]

If it is just EVA try these videos:

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

[joe1701]

Great tutorial my friend, but could you not just 'Advance Filter' the entire table and tick the 'Unique Records Only' check box. Please understand that I'm not being critical here, I love these tutorials and would be lost without you, I just wondered if this is also a viable alternative. Many thanks and keep up the great work.

[ExcelIsFun]

No problem. But since we don't want a total unique list, and instead we want to 1st find all duplicates, then from just the duplicates, extract unique records, we can just use a straight advanced fliter unique lis.

[wwwyalecom]

hi, nice trick!

I am just wondering how did the popup menu show up at about 1:15 of the video, course nothing happened when i try to do like that.

Thanks!

[ExcelIsFun]

1) Highlight

2) Right-click egde of highlighted area

3) Drag and drag back

4) then the menu pops up

[wwwyalecom]

@ExcelIsFun

done! Tanks a lot!

[ExcelIsFun]

You are welcome!