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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can get unique value
my example file is the same http://aljany.com/My_Book_sample2.xls
I wish to select all values from a column 2 by value autofilter chosen in a column 1 How to write expression? For Each icells In ................................. ? Worksheets(2).Cells(i, 1) = icells i = i + 1 'MsgBox icells Next icells but i see error May be do without loop? Help me some one please :( "Valery" wrote: 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. |
Reply |
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 |