Go back to the beginning of a list after reaching the end

		Microsoft Office Forums > Microsoft Excel > Excel
Go back to the beginning of a list after reaching the end

FAQ

Thread Tools

Display Modes

06-09-2021, 06:44 AM

xexeu

Windows 10 Go back to the beginning of a list after reaching the end

Office 2016

Novice

Join Date: Oct 2018

Posts: 7

Go back to the beginning of a list after reaching the end

As can be seen in the attached worksheet Saff_roster.xlsx has a relationship with 207 workers. Let's assume that the next one to be cast is number 200, Mr. Omar Kaniosky, and we have to cast 20 workers. So the scale starts at the number 200, goes to the end of the list and goes back to the beginning of the list to complete the task.
What formula should I use in this case?

Thanks in advance

Attached Files

Staff_roster.xlsx (11.4 KB, 7 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When placing a graphic, I am taken back to the beginning of my document	pharlow	Drawing and Graphics	3	10-25-2018 08:00 AM
send Reminder Email to Outlook if cell value reaching before due date	sathishsusa	Excel Programming	4	07-23-2017 01:38 PM
How remove a line reaching across the page	peytontodd	Word	1	05-27-2017 05:04 PM
2010 Mail Merge Directory how to print back-to-back w/2 pages per sheet	captaintms	Mail Merge	4	08-13-2015 06:21 AM
Making the second line of text in a numbered list wrap back to the left margin	aaron12345	Word	1	06-19-2012 05:29 PM