Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort by only one appearence
Is there a way to sort a row in Excel to sort a number of cells that have
multiple entries and view a list of just one occurrence of each different types in the row. OK if I have a row with 200 cells with 30 different types of the subject. I would like to sort to produce a list of just one each of the 30 different types of data. If I have coins and have ten nickels, 25 quarters, and 50 dimes. I would like to make a list that just has nickel then dime then quarter because there are three different types in the row. . Thank you in advance. |
#2
|
|||
|
|||
Hi Mike
you can't "sort" to get a unique list, but you can use data / filter / advanced filter to extract a unique list to another location and then you can sort that if you want. Debra Dalgleish has good notes on her site (http://www.contextures.com/xladvfilter01.html) on extracting unique entries using the advanced filter. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Mike Busch" wrote in message ... Is there a way to sort a row in Excel to sort a number of cells that have multiple entries and view a list of just one occurrence of each different types in the row. OK if I have a row with 200 cells with 30 different types of the subject. I would like to sort to produce a list of just one each of the 30 different types of data. If I have coins and have ten nickels, 25 quarters, and 50 dimes. I would like to make a list that just has nickel then dime then quarter because there are three different types in the row. . Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |