use drop down list to sort the data

[sarinky]

Hi Everybody,

Is there a way that we can use drop down list to sort the data?
the reason I ask this because I have a huge data set and I think if we can just make drop down list to sort which is more faster.

Hope this problem is clearly explained.

Sarin

[Mordred]

Have you tried using a filter?

[sarinky]

In my worksheet, I need to right formula for each (Ex: each province, or each branch). So I need to sort for specific province or branch, then write the formula. If I use filter, the formula does not work because the selection will include the hidden data.