don't know a title 2

[smiley0q0]

ok, here is my question... i have a column with several different names, some of them multiple times, how can i go through the list and just pick out each name only once...

A B
Fred Fred
Jack Jack
Jack Wilma
Jack Rick
Jack
Wilma
Wilma
Wilma
Rick
Rick

any ideas?

 

[MisterC]

Use the Data|Filter|Advanced Filter command on your menu.

 

[JVFriederick]

Easy.

1) Data Filter AdvancedFilter
2) Copy to another location
ListRange = A1:A11
CopyTo = B1
UniqueRecordsOnly

You will then get a list (with a header of "A&quot starting in B1.

Who is Wilma ?

 

[smiley0q0]

Wilma is Barney's wife.... i couldn't remember Fred's wife's name... all i can remember is dino, bam-bam, and pebbles....

thanks for the help... it works great.I i feel very educated today

 

[MisterC]

Actually Wilma is Fred's wife. Betty is Barney's s-)

 

[smiley0q0]

Oh yea!!! that's right... i have always gotten those 2 mixed up... don't know why... thanks! X-)

 

[JVFriederick]

Looks like MisterC knows his Flintstones !

I always thought Wilma was kind of bossy.

 

[smiley0q0]

yep, i'm sure glad we don't have to drive those kind of cars anymore, they must have been TERRIBLE on ling road trips!!

question... when i do that advanced filter thing, my first name is coming up twice... any reason? i thought it might be putting a title for the column... will it always put the first one twice?

 

[MisterC]

Advanced Filter requires a header row in your data - it is treating your first data row as the header so you see it twice.
To resolve this, give your data a header row.
By the way, I still drive a car like Fred's (seems like it sometimes anyway...)

 

[smiley0q0]

Thanks guys, you have really helped me today.... i gave you both stars.... you're awesome!!!

 

[JVFriederick]

Stars are always welcome. X-)

Probably gives away what I lacked during I days . . . .

 

[Dreamboat]

Well, Mister C! Welcome to you!!

(Come to join the fun, eh?)

As for the Flintstones, Betty giggled so much it makes one wonder about Barney--the shy, quiet type, you know!


techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[MisterC]

Hey, Dreamboat, and thanks for the welcome. Its an honor to be welcomed by one of this forum's top experts! :->

 

[Dreamboat]

That just means I'm a little more addicted than most... you won't see me in any of the other forums either.
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[MisterC]

I see you are an instructor. Do you teach all of the MSOffice suite? On what level?

 

[Dreamboat]

I chose instructor when I first logged in because it was the closest thing to what I do, which is over-the-phone software support for a firm with BIG client companies. I did start instructing on the MS Office suite about a year ago, part-time in the evenings. Intro and Intermediate is all I've taught. Usually one-on-one, occasionally two or three students at a time.

You sound curious about something. Feel free to email me if you have any questions, and we'll quit spamming these poor people!
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com