| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can get unique value
Hello!
I have a sample file http://aljany.com/My_Book_sample2.xls And i have two columns ( column of Year & column of Month) with active autofilter in them. Questtion: I need get all unique values for example with 1977 And after that, list of all unique values for 1977 from column 2 , copy (without visual effect of copying) to range cells on other sheet But autofilter in this two columns should remain active. Thanks for you time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
| How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Automate unique data to move to unique worksheets | Excel Programming | |||
| Formulas for...1. Counting unique cells 2. Display unique contents | Excel Programming | |||
Threaded Mode
