excel - Unique List from Column and Related Columns using Advanced Filter -


i'm using code retrieve unique values column.

sub finduniquevalues(sourcerange range, targetcell range)     sourcerange.advancedfilter action:=xlfiltercopy, _         copytorange:=targetcell, unique:=true end sub 

it works in getting list of unique items, how modify code pulls related columns?

thanks!


Comments

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

javascript - Complex json ng-repeat -

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -