Finding matching values using excel vba
Without using excel built-in filter or pivot table function, I want to
extract some results using vba. Consider the following example: given data
in coloumn A and B, I want to be able to input "a" in C1 and using the vba
to get in Column D all the corresponding values from column B (1,3,5). If
I input "b", I get 2, 6, so on. Thanks.
No comments:
Post a Comment