Excel Help

TiZakit · 09-September-07, 12:01 PM

Well, I'm stumped at this one, and I'd really hate to do it manually. I figured I'd throw this one out there.

So, I have the attached list, and I want to remove the duplications of the artist/album, so that I have a list of all the albums. This list was generated with tag scanner.

Also, if anyone knows of a program that will give me the same final result (it doesn't have to be an excel document though) please let me know.

Thanks in advance guys.

Rob · 09-September-07, 12:11 PM

Here you go....you have to sort unique fields under the data tab.

TiZakit · 09-September-07, 12:35 PM

Thanks, though I'm sure that I don't understand what you did. I cannot duplicate your result. Could you be a bit more specific?

Freakin' Excel genie.

Edit: I believe that I replicated your result using the filter command. Thanks!

Rob · 09-September-07, 12:54 PM

Which version of Excel are you using?

TiZakit · 09-September-07, 01:01 PM

2003

Which are you using?

Rob · 09-September-07, 01:04 PM

2007

I really don't remember how to do it in 2003, but you do it by selecting advance options on your filter menu. One of the options should be filtering the list in place and only showing unique records.

09-September-07, 12:35 PM		#3 (permalink)
TiZakit Apex Tech Demi-God	Re: Excel Help Thanks, though I'm sure that I don't understand what you did. I cannot duplicate your result. Could you be a bit more specific? Freakin' Excel genie. Edit: I believe that I replicated your result using the filter command. Thanks!

09-September-07, 12:54 PM		#4 (permalink)
Rob Advocatus Diaboli	Re: Excel Help Which version of Excel are you using?

09-September-07, 01:01 PM		#5 (permalink)
TiZakit Apex Tech Demi-God	Re: Excel Help 2003 Which are you using?

09-September-07, 01:04 PM		#6 (permalink)
Rob Advocatus Diaboli	Re: Excel Help 2007 I really don't remember how to do it in 2003, but you do it by selecting advance options on your filter menu. One of the options should be filtering the list in place and only showing unique records.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro in Excel 2003	Reverend KWR	Coding / Scripting / Programming	2	15-March-06 06:15 PM
The Register // More Excel madness	Gizmo	The Register RSS	0	08-March-06 03:04 PM
Looking for Excel	NoSlak	Trading Post	3	19-November-04 06:18 PM
Got EXCEL? Need feedback	Fu3lman	Anything Goes	10	10-April-04 12:23 AM
Help with Excel graphs?	Jonny English	Graphics / Media	6	29-March-04 04:39 PM