Any help would be appreciated. I currently have a drop down menu, 1-12, and a list or column of names that I would like excel to number (in column B) depending on the selected drop down. For example, I select 5 from the dropdown menu. Next to the first column (Column B) , I would like it to number in the following order: 1,2,3,4,5,2,3,4,5,1,3,4,5,1,2 ... until all the names from column A are numbered. Does anyone have an idea on how to do this? Or the Formula I would use? Thanks in advance.
Bookmarks