Delete rows once the two criteria are met

Hello MR. Excel ,

Please help me delete rows if two conditions are met .THe sample data looks as shown below:

I need to check for a given resource where the allocation hours are highest against which project , and then delete the rest of the rows for that resource records.If the Allocation hours are the same , then the priority column should be considered the highest priority should be included and the rest to be deleted.And if the priority is also the same then need just one record to remain rest of the rows to be deleted.I have priority of business area ranging from

Resource Name Resource ID Project Name Business area priority Allocation hours
Lavanya 123243 Marketing Sales 1 45
Lavanya 123243 Sales Sales 1 150
Mukund 5678 Re engineering Retail 2 10
Mukund 5678 Streamlining Generic 9 90
Mukund 5678 documnentation Documentation 8 50

hello sir ,

Will that take care of allocation hours , priority of each record ?doesnt seem to be the case

sAMPLE.xlsx


I have given the input and output in the same sheet , kindly take a look and advise .I have around 4000 rows of info in my worksheet if you can help me it would be great .

Hello Sir ,
There will be blanks also in allocation hours column , then the record that needs to get populated would be based on priority.Again if the same priority is repeating any one records has to be selected.