Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2021, 02:09 AM
xexeu xexeu is offline Go back to the beginning of a list after reaching the end Windows 10 Go back to the beginning of a list after reaching the end Office 2016
Novice
Go back to the beginning of a list after reaching the end
 
Join Date: Oct 2018
Posts: 6
xexeu is on a distinguished road
Default Go back to the beginning of a list after reaching the end

Hello



I have a list of 30 employees who are next scheduled. What formula should I use when the roster is at the end, for example at number 26 on the list, and I have another 15 employees roster? In other words, 26+15, in such a way that the list will filled again with employees from the beginning?
Thanks in advance.

Last edited by xexeu; 06-09-2021 at 10:15 AM. Reason: Solved
Reply With Quote
  #2  
Old 06-09-2021, 03:06 AM
Purfleet Purfleet is offline Go back to the beginning of a list after reaching the end Windows 10 Go back to the beginning of a list after reaching the end Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Can you provide and example workbook so we dont have to waste time recreating? it also helps explain what you want
Reply With Quote
  #3  
Old 06-09-2021, 06:44 AM
xexeu xexeu is offline Go back to the beginning of a list after reaching the end Windows 10 Go back to the beginning of a list after reaching the end Office 2016
Novice
Go back to the beginning of a list after reaching the end
 
Join Date: Oct 2018
Posts: 6
xexeu is on a distinguished road
Default 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
File Type: xlsx Staff_roster.xlsx (11.4 KB, 5 views)
Reply With Quote
  #4  
Old 06-09-2021, 09:43 AM
Purfleet Purfleet is offline Go back to the beginning of a list after reaching the end Windows 10 Go back to the beginning of a list after reaching the end Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Somthing like this?

First stab, so proabably can be done better.

Put the first user in H2 and the number of staff in h3 then the fiormula will update & anyone with a number is in, so you can filter out blanks
Attached Files
File Type: xlsx Staff_roster_ar12.xlsx (18.0 KB, 6 views)
Reply With Quote
  #5  
Old 06-09-2021, 10:08 AM
xexeu xexeu is offline Go back to the beginning of a list after reaching the end Windows 10 Go back to the beginning of a list after reaching the end Office 2016
Novice
Go back to the beginning of a list after reaching the end
 
Join Date: Oct 2018
Posts: 6
xexeu is on a distinguished road
Default

Thanks to Mr. Purfleet.

Brillant answer!
Reply With Quote
Reply

Tags
formula help

Thread Tools
Display Modes


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
Go back to the beginning of a list after reaching the end 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft