Result in list box depending on condition

[jimpatel1993]

Hans
I know I am really annoying you.
Just found last night that I need a option for following logic pls. I tried to put my head around but no luck.
Can you please point me the direction when you got time please.
Instead of averaging syntax Format(sunAndy/cntAndy, "0.00") I would like to take each different number individually please.
That is when I select Andy(v110) and Rajor(400), for both names Andy is same 70 runtime. So result will be
2....70....Andy(v110),Rojor(400)
For Andy(v110) description James is 55 and for Rojor(400)description James is 180 so result will be
1....55...Andy(v110)
1....180...Rojor(400)
And so on
Really apologies and hope its not big change
Really appreciate your time

[HansV]

That was quite a big change. I had to rewrite a considerable part of the code.

Conditions (1).xlsm

[jimpatel1993]

Is it
Apologies for this
This is amazing work.
Thanks a lot for your effort and time

[jimpatel1993]

Thanks for looking at my post.

I have added box called “Random Numbers”.

My question is for box “multiply1, multiply2 and multiply3”

Basically, I wanted to do the logic what I have attached.

Scenario1: Depending upon random numbers I wanted to divide and multiply

Example in scenario1 where 90/8*55

Where 90 is from result number, 8 is the random numbers and 55 is from james



All I worrying is data from james box.
Finally is it possible to transfer final result to sheet named as results with results transferring from A5 for Multiply 1,B5 for Multiply 2 and C5 for Multiply 3 respectively with following logic please.

In this case final result will be 90/8*55 will be 618.75. The data what I need to transfer to A5 will be 618.75/55 will be 11 times of 55. So can we transfer 11 times of 618.75 from cell A5 till A15



Scenario 3:



Final result will be

Multiply 1: 50/2*55 =1,375

So 1,375/55 will be 25. Can we transfer 1375 for 25 times from cell A5 till A24 please?
In Multiple 2: 50/2*50 = 1,250

So 1,250/50 will be 25 again. Can we transfer 1,250 for 25 times from Cell B5 till B24 please

Thanks again

[HansV]

Do you want this to happen automatically when the random numbers box is changed (automatically overwriting previous results), or should there be a command button for this?

[jimpatel1993]

Command button is preferable Hans
Thanks a lot again

[HansV]

Here is a modified version:

Conditions (1).xlsm

[jimpatel1993]

Thanks a lot Hans for your time and effort.
I will try this afternoon.
Thanks again

[jimpatel1993]

Thanks a lot Hans
Its fabulous work
Just one question
What should I do to get actual value in the Multiply box?
I am getting fractional numbers and not final result. May be I explained poorly in my initial question.
Thanks again

[HansV]

The way you showed it, I thought you wanted the expression in the text boxes and the result in the Results sheet...
Here is the new version.

Conditions (1).xlsm

[jimpatel1993]

Very sorry for poor explanation
Thanks a lot for the updated version
Really appreciated Hans
Thanks