Distribute a numerical range between some people

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Thanks. Please update your location in your profile as requested.

Here is a basic approach solution. See if it works for you.

Please Login or Register  to view this content.

You will most likely need to change commas to semi-colons for your Spanish locale. If that's not it, then define "can't make it work".

try again, here is your local state formula to see it works or not ?

before doing this , please make sure clear the content of cell B10 , and then start from cell C10

Formula:

Please Login or Register  to view this content.