Just follow the suggestion and you will ALL the unique ...
AND, you have your return address set to you versus the
list ... ( I
was wondering why I wasn't seeing the other responses )
thank you,
Wyatt Lemmons, HSG
(425) 830-5962 4x10 Wrk Sch ( Fri OFF ) & Telecommute:
Wed
-----Original Message-----
From: Alpesh B. Shah [mailto:alpesh9 MTNL.NET.IN]
Sent: Thursday, September 28, 2006 6:53 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Question
RE: QuestionDear
Thanks
Your are right. But As far as I know the filter function I
have to
filter for one Unique name a time I want a formula which can
picks up
the comman name out of 1000 rows and write in another cell
----- Original Message -----
From: Jon Tydda
To: 'Alpesh B. Shah'
Sent: Thursday, September 28, 2006 07:15
Subject: RE: Question
Alpesh
Rich is right, you want to use the advanced filter to show
only unique
names.
Jon
-----Original Message-----
From: Alpesh B. Shah [mailto:alpesh9MTNL.NET.IN]
Sent: Thursday, September 28, 2006 2:46 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Question
Dear Rich.
No I dont want unique names to look. I have 1000 rows data
whcih
contains
lets say 35 names used at a random basis.
Now I want only this 35 names out of 1000 rows to pick up
in another
cell
Alpesh B. Shah
----- Original Message -----
From: <Rich.Jensenstate.sd.us>
To: <alpesh9mtnl.net.in>
Sent: Thursday, September 28, 2006 07:10
Subject: RE: Question
If what you want is a list of unique names look at the
advanced filter
and use it to extract the unique items from you list.
-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Alpesh B. Shah
Sent: Thursday, September 28, 2006 8:39 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Question
Hi to All,
I have one Problem comes up while working with the
database in excel
Problem as follow.
Name
Name 1
Name 2
Name 3
Name 4
Name 1
Name 3
Name 4
Name 2
Name 4
Name 1
Name 3
I have in Name database the different Individual names
appears. as
shown
above.
Now I want to in another cell to write a formula which
will go the
name
database and write one below another the common. So
finally my results
will like this
Name 1
Name 2
Name 3
Name 4
My database is running in 1000 rows
Alpesh B. Shah
------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
The information in this e-mail is confidential and may
also be legally
privileged. The contents are intended for recipient only
and are
subject
to the legal notice available on request from :
webmasteralcontrol.co.uk
ALcontrol Laboratories is a trading division of ALcontrol
UK Limited.
Registered Office: Templeborough House, Mill Close,
Rotherham, S60
1BZ.
Registered in England and Wales No 4057291
------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|