i have a of question regards to "sort?"
 

Please help me!!!

i've sorted some fruits like below
Apple
Apple
Orange
Orange
Peach
Peach
Peach

is there anyway to list only types of fruits?
say,

apple
orange
peach

listed only once, no repeating

thank you!!

i have a of question regards to "sort?"
 

Add headers if you need to.
Then use Data|Filter|advanced filter (xl2003 menus)

Debra Dalgleish explains it he
http://www.contextures.com/xladvfilter01.html#FilterUR

doyree wrote:

Please help me!!!

i've sorted some fruits like below
Apple
Apple
Orange
Orange
Peach
Peach
Peach

is there anyway to list only types of fruits?
say,

apple
orange
peach

listed only once, no repeating

thank you!!

--

Dave Peterson

i have a of question regards to "sort?"
 

wow thanks!

that really hit the spot!!
though, i'm trying to find out why one item repeats.

ex)
1
2
3
4
1
2
3
4

then i got
1
1
2
3
4

thanks!

"Dave Peterson" wrote:

Add headers if you need to.
Then use Data|Filter|advanced filter (xl2003 menus)

Debra Dalgleish explains it he
http://www.contextures.com/xladvfilter01.html#FilterUR

doyree wrote:

Please help me!!!

i've sorted some fruits like below
Apple
Apple
Orange
Orange
Peach
Peach
Peach

is there anyway to list only types of fruits?
say,

apple
orange
peach

listed only once, no repeating

thank you!!

--

Dave Peterson

i have a of question regards to "sort?"
 

You need to have a header - without one, Excel will assume that the
top item in the list is the header, so if it appears elsewhere in your
list it will be shown twice.

Hope this helps.

Pete

On Feb 1, 5:03*pm, doyree wrote:
wow thanks!

that really hit the spot!!
though, i'm trying to find out why one item repeats.

ex)
1
2
3
4
1
2
3
4

then i got
1
1
2
3
4

thanks!



"Dave Peterson" wrote:
Add headers if you need to.
Then use Data|Filter|advanced filter (xl2003 menus)

Debra Dalgleish explains it he
http://www.contextures.com/xladvfilter01.html#FilterUR

doyree wrote:

Please help me!!!

i've sorted some fruits like below
Apple
Apple
Orange
Orange
Peach
Peach
Peach

is there anyway to list only types of fruits?
say,

apple
orange
peach

listed only once, no repeating

thank you!!

--

Dave Peterson- Hide quoted text -

- Show quoted text -