Home » Forums » Open Source Learning Center » Question and Answer

Automating allotment

Submitted by A Kumarsreenivas on 5 December, 2012 - 20:05

Hi Team

Please find the attached Query sheet.

I have some 100 documents in column-A of sheet-1.
I have to distribute those equally between say 4 operators as shown in column-B.
Operators' list is placed in sheet-2.

Please let me know if there is any smart way to do this rather than copy-paste each operator name and then duplicating down.
Please suggest a pure excel way without getting into vb scripting.

Thanks & Regards
Kumar.

Please find the attached tested sheet.

Thanks & Regards
Kumar.

AttachmentSize
Query120612.xlsx15.03 KB
‹ Random Drawing for a Bicycle from a list conditional formatting with date and time ›
»
Jose Maria Murillo's picture

similar problem

Submitted by Jose Maria Murillo on 9 December, 2012 - 19:29.

Download "my solution"

https://www.box.com/s/pdlwnvjj8px83iowd9u6

Regards

»

This is brilliant. Thank you

Submitted by A Kumarsreenivas on 9 December, 2012 - 05:17.

This is brilliant.
Thank you Jose.
Finally you got it and suggested the correct way to automate the allotment.

Hope this works in more complex scenarios too. I will get back to you if any problem persists.

Once again thank you for the great support.

Regards
Kumar.

»