how to know in which order it is sorted

Hi,

I have some headers in my sheet. When they click on the header it has to be sorted.

When it is sorted by ascending and next time when they click header I want it to be sorted by descending.

Right now I have implemented to sort Descending . Now how will I check in which order does it sorted?

If know the order in which it is sorted currently then I will sort it in the opposite way..

Please Login or Register  to view this content.

Please edit your post to add code tags.

If the firsrt value in the range is less than the last, it's sorted ascending.

If a list is already sorted, then if the first value in the list is less that the last, the list is sorted ascending.