Sort sheet based on 2,5 criterias

Hey guys.

Let me try and explain what is a 2,5 criterias. I have a sheet that is sorted using a filter. The sorting criterias is such that:

First: column S - sorted by letter (I want all O's coming at the top of the list and whatever row that doesn't have an O in column S should only be sorted based on column A criteria)
Second: column A - sorted by date

Basically this is what I want:

want.jpg

But this is what I get:

get.jpg

These are the sorting criterias:

sorting.jpg

Any thoughts on how to sort this would be much appreciated.

Hi newdoverman. Thank you for your reply.

I guess I didn't quite understand what you said.
What's happening is that Excel is bringing rows that contain 'O' entered in column S to the top - which is what I want - and then sorting the rest in alphabetical order - which isn't what I want. Only after sorting column S, it sorts column A by ascending date.

I have attached the file as you requested.
Maybe creating two separate filter it would do?

Thanks.

Hi newdoverman.

The letter O stands for "ongoing projects", whereas C stands for "completed projects", and W stands for "withdrawn projects".
What I want is that "ongoing projects" stay at the top of the list just so it is easier to edit them.
It happens that I found my way around this. I assigned "completed projects" (C) and "withdrawn projects" (W) as number 1 in clomun Z. "Ongoing projects" (O) were assigned 0. Then, I sorted the list in ascending order based on column Z and column A, instead of column S and column A as before. And that's it.

Thanks for helping mate.