By people that have no idea how the average user will interface with their program.

This is how I do it now. I don't want to take 5 minutes. I want to do it in seconds.

It still leaves duplicate values, plus they are all still in separate columns.

To do it now, I move all the columns into a single column and then use the Remove Duplicates button. Too tedious.

Learn VBA

Thanks, I'll get right on that! :thumb:






:rolleyes:

then your best bet is using a pivot table

Well, you did ask for the advice. Some light VBA coding would make it a routine process.

Hell you could probably google what you're looking for and find the VBA code too.

If you can get your hands on a copy of MS Access and learn some very, very basic queries your prayers would be answered.

I'll see what I can find. Thanks.

For the pivot table suggestion, I'm still not sure how that works. Can someone elaborate?

Are you using 2010? If so, it pretty much walks you thru the process.

Just so you don't have to get familiar with Pivot Tables and formula arrays etc this moment, you can do a quick work around until you get to that point.


1. Get all your data into one column
2. Insert row at Row 1 and label cell A1 anything; for example "a". It's needed to accomplish this but you can delete it afterwards.
Select entire column, copy, and paste into a new tab (just so it’s easier to look at for you) column A
3. Highlight column A
4. Next to the Filter icon, you should see an ‘advanced’ button; click this.
5. Click the ‘Unique records only” box
6. Click the ‘Copy to another location’ radio button
7. Click within the “Copy To” box, then simply click in the spread sheet where you want the data.
8. Click ok.
9. Boom

Once I get to this point, it's just as easy to use the Remove Duplicates function.

:banghead:
SHIT.. lol. yeah, I didn't think of that.

This!

Yup.

http://dailydoseofexcel.com/archives...elected-cells/