| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Linear Mode
