Convert Series into Range.

[Admin]

Hi

I got the same results what you shown in the picture. So what's no working for you ?

1.JPG

[ayazgreat]

Kris I mean to say if I say there are different numbers in series with their MB number in col b if there is a single number in series like 307392589 then result should be 307392589 to 307392589 equal 1 in Qty or count col but result in your code is equal to 3 not 1