Priority setting based on five conditions

[Nur Hossain]

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 . I know it is little bit complex task , but also believe  macro programmers can make my job easier.
please find the attachment

​

Below I have tried to explain all this (I am ready for more clarification also)

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

 

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

 

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

 

3^rd 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

2^nd 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

 

3^rd 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

Nur

[Vaibhav Joshi]

Hi Nur,

check this macro...

Cheers!!

PS: Need to visit group page to download attachment.

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab - An Excel VBA Macro help Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CAHOz6o_eUvxhMiDSUjAfom0bwFQgWLoggD61CUAK0WjrevPMGA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[vabs]

Hi Nur,

check this macro...

Cheers!!

PS: Need to visit group page to download attachment.

[Nur Hossain]

Vaibhav Joshi da:

Yes it  works perfectly !!!, now  it takes only moments to set the priority ,i really appreciate your nice job , I am very much pleased and  really grateful to you , thanks for your valuable time in this regards , it will help me a lots , wishing you a very happy life & stay safe all time…byee  

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CALu41JDZE9aM5EA4GfbwP10iVUTPgx%3DmaN1fZkjEO_f%3DTo5O8A%40mail.gmail.com.

[Vaibhav Joshi]

Cheers!! great this helped you..

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CAHOz6o-4%3DNuQwYpaZirm3P%3DTY3Q6N%2BcrT%2BLinQvZij2cOg3DMw%40mail.gmail.com.