1 min readfrom 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!

submitted by /u/ScrewPCx
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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