#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Can you provide and example workbook so we dont have to waste time recreating? it also helps explain what you want
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Thanks to Mr. Purfleet.
Brillant answer! |
Tags |
formula help |
|
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 |