i have 2 sets of data, Set1 contains 40 different codes
Set2 contains full year data and all different codes.i only want to pick out these 40 codes in Set2,
i thinking to do MATCH, but match seems to be only able to do 1 value match....
out of idea, please help
thanks
I'm not clear on what you are trying to do. Have you looked at the Advanced Filter feature? See here: http://office.microsoft.com/en-us/e...
It might help if you posted an example of your data with an explanation of what you are trying to do. Before posting example data, please click on the following line and read the instructions found via that link.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
solved!
thank you very much!