Forum Discussion
How to Automate a Rostering System
Hello, and thank you to all who respond constructively. I am currently attempting at automating a rostering system for 50 employees. They are unionized, and they have the ability to bid on differe...
=IF(AND(COUNTIF($B$1:B1,B2)=0,COUNTIF(B2:D2,B2)=0),B2,"N/A")
This formula checks if the value in cell B2 is unique in the range B1:B2 and in the range B2:D2. If the value is unique in both ranges, the formula returns the value in cell B2. Otherwise, it returns “N/A”.
You can use this formula to check if an employee’s bid is unique among all bids in the same row and among all awarded bids in the column above. If the bid is unique, it can be awarded to the employee.
However, this formula only checks one bid for one employee. To automate the process of awarding bids for all employees, you may need to use more advanced techniques such as Office Scripts or VBA.