•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need a list of names from a schedule to populate based on what day of the week it is and if they are scheduled to work that day.
I want the schedule above to go into a separate list that only includes people that are working that day, in alphabetical order automatically.
I don't want them spaced out on the second list, I want it neatly organized.
EX:
Formula: =SORT(FILTER(B20:B29, ISNUMBER(C20:C29), " "))
This formula only works with one column, but I need it to change based on what day of the week it is.
Thanks,
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#cloud-based spreadsheet applications
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#schedule
#names
#working
#list
#Excel
#day of the week
#formula
#alphabetical order
#SORT
#FILTER
#ISNUMBER
#neatly organized