1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

# round robin assignment

Discussion in 'Ask an Excel Question' started by sharath.rk, Mar 12, 2018.

1. ### sharath.rkNew Member

Messages:
1
When tickets are assigned to Engg. they should be assigned in a circular fashion to the agents who are available in that group.

Eg: I have multiple queue. I want to use. Round-robin method equitably distributed

Let say I have2 queues for Tier3 and tier2. I have 2 engg in tier 3
Now I want ticket to assigned to engg in tier 3 in roundrobin method

First ticket to first engg , Second to second engg and third INC first engg name again

And same method to be used in other groups as well. Any suggestion how can I achieve this?

this process is explained in this saleforce link. can this be achive in excel?
2. ### ChihiroExcel Ninja

Messages:
5,108
I'd recommend uploading sample workbook set up with enough data to demonstrate your need. Without it we'd be guessing.

Typically I do this type of operation using code, if I had to do it in Excel. But others may have formula solution.
3. ### NARAYANK991Excel Ninja

Messages:
16,619
Hi ,

This is a straightforward exercise ; use the formula :

=INDEX(List_of_Names, MOD((ROW(A1) -1), MIN(N,ROWS(List_of_Names)))+1)

where List_of_Names is a reference to a range where the names have been listed. N is a cell which has values from 2 through any number.

Thus , if you have 5 names , A , B , C , D and E , then with N = 3 , you will have an output :

A , B , C , A , B , C , A , B , C ,...

Putting N = 5 will result in an output of :

A , B , C , D , E , A , B , C , D , E , A , B , C , D , E ,...

Narayan