Hi Team, Need help on logic, I am working on ticket allocation system using excel data.
in Assignment_Agnet file will get all info regarding need to assign to new hire or tenured folks (Col A),
in Agent_Info file will get how many new hire and how many tenured folks available.
We will get info regarding how many ticket are there to assign in file Assignment_Agnet(Col A).
I need to distribute equally all ticket to new hire and tenured folks in file Assignment_Agnet (Col ,
Ex: if there are only 2 new hire are available, and new to assign 6 ticket to new hire, then we need to assign 3,3 to each agent.