Help continue serial between two Value

[jessica0007]

Hello everybody,

I need to help. I have two values a and b, a has a minimum value and b has a maximum value, The value of the between of these two is to be serialized.

thank you

[nankw83]

Hi jessica,

Try below code based on your sample file ...

Please Login or Register  to view this content.

[mjr veverka]

... a has a minimum value and b has a maximum value ...

Can the minimum value be zero ?

[jessica0007]

porucha vevrku,
No, the minimum value cannot be zero.

[jessica0007]

nankw83,
Wow the answer is almost correct, but there is a small problem, serial number 17 does not have the number 24 between A and B.

[nankw83]

but there is a small problem, serial number 17 does not have the number 24 between A and B.

I have actually noticed this difference but I though it was a typo from your end. The logic I used is to take the minimum & maximum for all values that fall under each serial number. While this logic works for Sr. # 14 it doesn't work for Sr. # 17 ... Maybe I am missing something that you can explain

[jindon]

Try

Please Login or Register  to view this content.

[jessica0007]

nankw83,
You are right, serial number 14 has the same value as 15,14, when I gave 15,16,17,18 it is wrong, I should have corrected this mistake in Excel, accordingly you created the code correctly . .

[jessica0007]

jindon,

Thanks for your code

[jindon]

The value of the between of these two is to be serialized.

.................

[nankw83]

I should have corrected this mistake in Excel

Post back another excel file with the correct expected results & I'll adjust the code accordingly

[jessica0007]

nankw83,
Please see the attached file.

[jindon]

Please Login or Register  to view this content.

[jessica0007]

jindon,
Thank you very much this is what I wanted..

[nankw83]

This is my attempt

Please Login or Register  to view this content.

[jessica0007]

nankw83,
Thank you very much...
That's perfect........

[nankw83]

Glad to help & thanks for the added Rep.