i have a of question regards to "sort?"

[doyree]

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]

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

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

 

[doyree]

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!

 

[Pete_UK]

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