Autofilter > Unique Values

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Nov 1, 2006

• #11

Do you have Name in A1 and in C4?

 

Upvote 0

MarkAndrews

Well-known Member

Joined

May 2, 2006

Messages

1,970

Office Version

1. 2010

Platform

1. Windows

• Nov 1, 2006

• #12

Do you have Name in A1 and in C4?

Click to expand...

Andrew - My data is as displayed in my post earlier?

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Nov 1, 2006

• #13

Following my instructions I got:

Book12
	A	B	C	D
1	Name
2	A94B94INs Processed:		TRUE
3	Alwin Fernandes
4	Amjad Shaikh		Name
5	Anup Batwar		A94B94INs Processed:
6	Arun Lazur		AUTHACTs Processed:
7	Audrey Natalia Soares		BLDPOLINs Processed:
8	AUTHACTs Processed:		BROKACCTs Processed:
9	Blandina Trindale		BROKAUTHs Processed:
10	BLDPOLINs Processed:		CANCELs Processed:
11	Bonaventure Dsouza		CHCERTINs Processed:
12	BROKACCTs Processed:		COMMSINs Processed:
13	BROKAUTHs Processed:		CONFINs Processed:
14	CANCELs Processed:		COTs Processed:
15	Cassandra Mascarenhas		Detail:
16	Charles Chettiar		Document Class:
17	CHCERTINs Processed:		Document Class: A94B94IN
18	Chetan Vikas		Document Class: AUTHACT
19	COMMSINs Processed:		Document Class: BLDPOLIN
20	CONFINs Processed:		Document Class: BROKACCT
21	COTs Processed:
22	Delilah Cowan
23	Detail:
24	Dhananjay Thingalaya
25	Divya Desai
26	Document Class:
27	Document Class: A94B94IN
28	Document Class: AUTHACT
29	Document Class: BLDPOLIN
30	Document Class: BROKACCT
Sheet1

 

Upvote 0

MarkAndrews

Well-known Member

Joined

May 2, 2006

Messages

1,970

Office Version

1. 2010

Platform

1. Windows

• Nov 1, 2006

• #14

How would i get the list in C to be the names only, as opposed to your post above?

 

Upvote 0