Thanks for the quick response Tobias.
I think it may be easier to take a different route.
I just noticed when I clicked on the sorting arrows for column F (sale 1), the descending arrow gives me the order that I want, being Live, In XX Days then Ended.
How can I set this up to occur automatically everytime I go to the page without hitting the sorting arrow.
Cheers