Sorting Problem

[rubikscube991]

In Column 1. (Proj), some project get repeated, some do not.
What I do is , first I sort the Project with Colour and seprate the duplicate projects from Unique Projects. No Prob till here

Now the the Problem Comes...
For the Repeated projects, lets say A. I have to look Column M1.
For proj A minimum Value is 8.9 in M1 column. I Want to keep this value and remove the Other 2 rows.
Similary for proj B also.
Value of M2, M3, M4 shall be as in front of A & 8.9...
Hw can I do this please Help...!!!
Resulting Table should look like yellow hilighted.

Refer excel sheet Please

Thanks a Loads for Your Kind help..

 

[Somendra Misra]

Hi Rubik,

See this file, I had added a helper column with a small array formula in column G and than sorted filter Column G with values >0 and than sorted column B.

Regards,

 

[Smallman]

Hi Rubik

See file attached.

Take care

Smallman

 

[rubikscube991]

thanks a load guys.. u wont believe we used to waste more than 2 hours for this...

thanks again..

 

[Somendra Misra]

You are Welcome Rubik!!!

Regards,