How can I add a condition in my loop that does not work?

Hey folks!

I've a problem with my code, basically this loop distribute a known number evenly 1 by 1 across a range where the known number is given by "TV Comodin" Row (in color Red) until the rows reach to 100 (limit) or the known number reach to 0 , the data set is as follow:

Captura.PNG

My code works, it identify the minimum value and then distribute the known number evenly 1 by 1 across the range, and once the known number reach to 100 or the known number gets to 0 it stops, the problem here is that the loop just should be adding the number 1 by 1 and stopping when it finish in the rows with the AB Category (given by the "SEGMENT" column ") . When I try to add this rule, it just not works and keeps adding the number in all the rows along the range, here is my try:

Please Login or Register  to view this content.

the desired out put would be:

Sin título.png

any idea? hope you can help me guys, thanks ( I attached the data set, )

I think it's pretty clear, "pendejito", but no worries about it, friendly people in another forum helped me already. So in your language "I don't need you, dude". By the way "querés" and "falutas" are not even words in spanish, thanks

Originally Posted by xxkid

I think it's pretty clear, "pendejito", but no worries about it, friendly people in another forum helped me already. So in your language "I don't need you, dude". By the way "querés" and "falutas" are not even words in spanish, thanks

I think it's pretty clear, "pendejito", but no worries about it, friendly people in another forum helped me already. So in your language "I don't need you, dude". By the way "querés" and "falutas" are not even words in spanish, thanks