| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the number of types?
Hi Eric,
Try this link http://www.cpearson.com/excel/ListFunctions.aspx and the section Listing Distinct Elements In A List I was pointed in that direction by someone here recently and it worked a treat Cheers -- Mifty "Eric" wrote: Does anyone have any suggestions on how to determine the number of types? For example Under A column, there is a list of name, and under B column, there is a list of fruits. John Apple Mary Orange Ann Banana Michelle Apple Peter Mango Smith Banana Sam Banana I would like to know a list of fruits, and shows them in C column without duplication. Apple Banana Mango Orange Does anyone have any suggestions? Thank you very much for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| How to determine the number from given condition? | Excel Discussion (Misc queries) | |||
| Determine Row number | Excel Discussion (Misc queries) | |||
| Counting the number of Error Types | Excel Worksheet Functions | |||
| How to determine the number of units? | Excel Discussion (Misc queries) | |||
Hybrid Mode
