| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a filtered list
I have a worksheet (MAIN) that has alist in column "A" starting from "A11"
downwards. In this list items are added and may be repeated several times. How can I create a filtered list on a seperate sheet of the items. As new items afr added to sheet"MAIN" the filtered list gets updated. -- ASU |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating a filtered list
Hi
You need to use Advanced Filter For instruction on the use of Advanced Filter, take a look at the excellent instructions at Debra Dalgleish's site http://www.contextures.com/xladvfilter01.html#ExtractWs -- Regards Roger Govier "ASU" wrote in message ... I have a worksheet (MAIN) that has alist in column "A" starting from "A11" downwards. In this list items are added and may be repeated several times. How can I create a filtered list on a seperate sheet of the items. As new items afr added to sheet"MAIN" the filtered list gets updated. -- ASU |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed - creating invoice from packing list (both in excel) | Excel Discussion (Misc queries) | |||
| Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
| question about creating a simple drop down list | Excel Worksheet Functions | |||
| Creating a numercal list | Excel Discussion (Misc queries) | |||
| Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
Linear Mode
