Can't input the same numbers range in two Min Max variables

[jasonseril]

Hello All,

My requirement is to input a range of values to a four (4) input boxes, currently Im using four variables to get the two minimum and maximum values, the requirement is after inputting the first min-max values, user should not be able to input again the same values in the second min-max.

           EX:

                                Min:             Max:                 

Group 1 : ABC         10                 15

in Group 2's Min and Max, user can only input 1 and 9 or 16 to any numbers.

Any set analysis suggestions to this requirements?  Please help.

Thanks and more power!

Best regards,

Jason

[AbhijitBansode · Accepted solution]

Hi,

PFA.

Hope it serves your purpose.

[jasonseril]

thank so much, Abhijit.

[jasonseril]

by the way cabhijit what about user inputs this values:

                               Min      Max

     Group 1: ABC    10    -    15

however in

                                             Min         Max

     Group 2: DEF    any of  1 to 8  -   9 only

                                      or    16     -    any number higher than 16

Thanks.

[AbhijitBansode]

Hi Jason,

If your input for Group1 is ,Min -10 Max -15

Then constraints on input boxes of Group2 will take care of only allowing Min numbers in the range of 1to 9 and Max number >15 only.

Below are the constraints on Group2 input box:

Group2Min:

$ >= 0 and $<$(vGrp1Min)

Group2Max:

$>$(vGrp1Max)

[jasonseril]

Hi Abhijit,

I understand.  Let me explain the requirements, in Group1 the user inputs min=10 and max=15 so the range values for group1 is (10, 11, 12, 14, 15), Now for Group2, user may input min=1 to 8 and max=9 only, the range values for Group2 (1,2,3....9) or user may input min=16 to any number and max=17 to any number, now the range values for Group2 would be (16,17...).

i wonder if this is possible.

thanks again, Abhijit cabhijit

[AbhijitBansode]

If I understood your problem correctly,

does this attached suffice your requirement?

[jasonseril]

yes Abhijit, all thumbs up. thank you so much.

Br,

Jason