yogi_For List Of Cases And Reviewers In D2:D Assign Reviewer To Cases Evenly

Google Spreadsheet   Post  #2343

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-06-2018

question by: mpuchtel

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/5phOYwKYSY8;context-place=forum/docs

Assigning Challenge

Hi I have a challenge. 

In this sheet I have a list of cases in column A. I also have a list of reviewers names to the right. I want a formula in cell B2 that will read the reviewers list and assign a reviewer evenly to all the data by adding the reviewer's name into the B2:B fields. The result in this case would be Joe, Sandy, Mike, Joe, Sandy, Mike, etc going down from B2.

Also, as a twist, I want the formula to be able to do this regardless of the number of names in the reviewers list. I may add or subtract in the future.

What do you say?? :)

Thanks!

Max