Search results

Hi LtB Thanks for reaching out and sharing your problem with such clarity. It is quite a unique problem it seems. Most likely your Excel file got corrupted. We recommend you open the Excel file on another machine or try to restore it from a backup if available. There can also be issues with...

Hello Mukhis. Interesting take here. There is no default feature in Excel that can perform this kind of task as Excel prioritizes numbers over alphabets while sorting. However, you can use VBA to create such custom order priorities. Here is a code that can sort the way you wanted in the example...

Hello LordKasen, Excel's data validation creates a dropdown list from a single range at a time. You can manipulate it by combining two lists to create a unique one and then using the list as a source. However, the columns need to be side by side for that. Here is how you can create a dynamic...

Hello again! Usually, the shift rosters are set up to cycle the shifts of each person. The way you want, it is not possible to follow this pattern. i.e. if an employee has to start in the 2nd shift he may end up working in that shift for several days in a row. And even in that scenario, the...

Hi ezraroellstoa. You can try out this formula to fill in the shift automatically based on your desired preference: =IF(OR($D4="",F$3=""), "",IF(E4= "",D4, INDEX(Shift_Legend,IF(MATCH(E4,Shift_Legend,0)+1>COUNTA(Shift_Legend),1,MATCH(E4,Shift_Legend,0)+1)))) For this to work, you need the...