•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatically sorting employee list based on seniority and accepted/declined OT
An employee overtime call list goes in order by seniority, but then if an employee declines or accepts > 4 hours of OT, they get moved to the end of the list. If they only accept 4 hours or aren't called/available due to vacation, already scheduled, etc then they stay where they are.
How can I make a call list that automatically adjusts / sorts the call list order based on whether someone declines and accepts > 4 hours or not?
Example Emp 1 (declined) Emp 2 (Accepts 4 hours) Emp 3 (Not available) Emp 4 (Accepts 8 hours)
Would end up as Emp 2 Emp 3 Emp 1 Emp 4
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#cloud-based spreadsheet applications
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#employee list
#overtime call list
#call list
#seniority
#automatically adjusts
#employee
#accepts
#declined
#call list order
#4 hours
#sorts
#accepts 8 hours
#declines
#available
#vacation