Priority setting based on five conditions

Dear Macro Programmers ,
I am to do some priority setting activity on daily basis in two hours interval on my job. It is very much time killing and bothering activity for me , also some time I do mistake while manual priority setting , and for this mistake , I am to hear form my manager that I am less competence and not fit for this job! I will be very happy if I got a macro or formula solution for making it automation to smooth my
Activity . please find the attachment . I know it is little bit complex task , but also believe macro programmers can make my job easier. Below I have tried to explain all this (I am ready for more clarification also)

Attachment 460607

Before setting the priority on the Column G , I am to consider sequentially started from Column B to F
here 1st "ZONE" 2nd "HUB" 3rd "TAGGING" , 4th "DG" and 5th "MINUTES"

Lets consider for zone “R1 Jatrabari" , how to set priority “P1” & “P2” in the column G

So let’s consider first Zone wise, here “R1 Jatrabari" this zone having in two rows (row 2 and row 3), here in "HUB" column I have to consider that which the maximum value is? Here both are 5 , so I am to go to the next column "TAGGING" here I have to find out the maximum value , here 2 (in the range D2:D3) is the maximum value , as I am already got two consecutive height value in the first two columns (C:D), so I should not consider next two column(E:F) , I will put the priority “P1” , and obviously next one will be priority “P2”.

Lets consider for zone “R3 Khulna", how to set priority “P1”, “P2”,”P3”,”P4” and “P5” in the column G

1st Column “ZONE” , here “R3 Khulna" having 5 rows , what type of calculation I will do , I am to consider only these 5 rows .

2nd Column “HUB” , here the maximum values is 3 (in the range C4:C8) , I will keep in mind 3

3rd Column “TAGGING” here the maximum value is 2 (D4:D8) , I will keep in mind 2
As I already got two consecutives maximum value in the “HUB” and “TAGGING” columns, so put the priority “P1” in Cell G5. And priority “P2” will be at cell G4

Again
2nd Column “HUB” , here the maximum values is 1 (in the range C6:C8, please remember I will not consider cell C4:C5 as I already calculated and set the priority previously ) ,so I will keep in mind 1

3rd Column “TAGGING” here the maximum value is 1 (D6:D8) , I will keep in mind 1

As I already got two consecutives maximum value in the “HUB” and “TAGGING” columns, so put the priority “P3” in Cell G6.

now I have to consider CELL(C7:C8) ,here maximum value 1
in cell D7:D8 , here no maximum value , so I am to go to the next column “DG”
in cell E7:E8 , here maximum value 1 , as C7:D8 is similar value , so I will consider G8=1 value , and put
priority “P4” in cell G8, last one “P5” in the cell G7

Thanks

Maybe :

Please Login or Register  to view this content.

Hi karedog ,
Yes ! it works perfectly ,You safe my life ! I really appreciate your nice job, I am pleased & grateful to you , wish you a very happy life , thanks bro.

You are welcome nur2544, glad to help.
Thank you, and I wish you a happy life too.


Regards