| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with making a function to filter lists
hello. i am trying to sort through a list of data by displaying only one
occurance of a name from one column that has many repeating names into a new column. ex: A B C 1 apple apple apple pear pear apple pear orange orange orange banana banana is it possible to show in column "B" only one "apple", one "pear", one "orange", one "banana", etc? thanks in advance for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with making a function to filter lists
The easiest way is to use the Advanced filter.
Assuming A1 is your column header and the data is in the range A2:A13... Select the range A1:A13. Goto DataFilterAdvanced filter Select: Copy to another location Copy to: enter the first cell where you want the data to appear, like, say, B1. Select: Unique records only OK -- Biff Microsoft Excel MVP "monkeytrader" wrote in message ... hello. i am trying to sort through a list of data by displaying only one occurance of a name from one column that has many repeating names into a new column. ex: A B C 1 apple apple apple pear pear apple pear orange orange orange banana banana is it possible to show in column "B" only one "apple", one "pear", one "orange", one "banana", etc? thanks in advance for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with making a function to filter lists
Here's one quick n simple formulas play which can drill out a dynamic uniques
listing .. Assuming source names running in A1 down In B1: =IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",ROW())) In C1: =IF(ROW()COUNT(B:B),"",INDEX(A:A,SMALL(B:B,ROW()) )) Select B1:C1, copy down to cover the max expected extent of source data in col A. Hide away col B. Col C returns the desired list of uniques from col A, all neatly bunched at the top. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "monkeytrader" wrote: hello. i am trying to sort through a list of data by displaying only one occurance of a name from one column that has many repeating names into a new column. ex: A B C 1 apple apple apple pear pear apple pear orange orange orange banana banana is it possible to show in column "B" only one "apple", one "pear", one "orange", one "banana", etc? thanks in advance for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making wider drop down List for Filter | Excel Worksheet Functions | |||
| Filter lists | Excel Discussion (Misc queries) | |||
| Making multiple selections from Excel drop down lists | Excel Worksheet Functions | |||
| Filter arrows on drop down lists | Excel Discussion (Misc queries) | |||
| Making individualized word lists from a SS | Excel Discussion (Misc queries) | |||
Linear Mode
