How to sort a column based on two other columns which are differentplaces?
 

I have a column say "E" which I need to filter based on the content of
column "A" and Column "C".
How to do that?
when i sort it maually, the row numbers look like 1,3,6,8
How to retrieve them without including intermediate values?