Hi Andrew,

just one thought: A sorted list is always sorted no matter if it is filtered
or not. Turn screenupdating off, sort your list according to A *and* B,
filter, do whatever you like.

arno

This is the scenario. I need to filter the worksheet data with a criteria
that is in Column A,
After that I need to sort the values in Column B in ascending order then
display those values in another sheet
Those values should also be unique so if there are duplicate entries, the
duplicate is discarded. How can I do that in VBA?