Currently in the process of converting a sheet from Google to Excel due to work security requirements. In Sheets you have very useful and handy functions like SORT Filter and QUERY which Excel does not support. Even though MS says they have been Beta testing these for over a year, they still hav enot released it and will not say if and when they plan to. So here is what I need. The current Google formula is iferror(FILTER($L$1:$R$1,L2:R2="Off")) which looks to a range of cells and searches for the word "Off" and then returns that rows header in the empty spaces. The purpose of this is that we have data downloaded from another program by another department. That data comes to us for employee schedules, and has 7 columns each labeled with the days of the week, Monday, Tuesday, etc. Across from each employees name, the cell is empty if they work that day, and says "Off" if they do not. Some employees have two days off, some have three. I need to basically have the next three columns indicate the actual day of the week that the employe has off based on the previous seven columns. So column 1 through seven are labeled with headers of the weekdays, and starting in column 8 I need it to say the actual day of the week the employee has off.
As an example, employee 1 will have blanks in Sunday, Monday, Tuesday will say Off, Wednesday will say off, Thursday and Friday will be blank, Saturday will say Off.
Employee 2 will have Sunday and Monday say Off, and the rest will be blank
Employee 3 will have Sunday Blank, Monday and Tuesday will say off, and the rest will be blank.
So what I need is for the next three cells in the row to say for employee 1, Cell 8 will say Tuesday, cell 9 will say Wednesday, and Cell 10 will say Saturday
For employee 2 cell 8 would say Sunday, Cell 9 would say Monday and cell 10 would be blank
for Employee 3 cell 8 would say Monday, Cell 9 would say Tuesday and cell 10 would be blank
Bookmarks