如何在excel中使用公式创建FIFO队列? [英] How can I create a FIFO queue with a formula in excel?

查看:440
本文介绍了如何在excel中使用公式创建FIFO队列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一张这样的桌子:



 + =========== + === ===================== + 
| **姓名** | **完成的任务数量** |
+ =========== + ======================== +
|乔| 1 |
+ ----------- + ------------------------ +
|约翰| 1 |
+ ----------- + ------------------------ +
|艾玛| 0 |
+ ----------- + ------------------------ +
|索菲亚| 0 |
+ ----------- + ------------------------ +





我想通过公式从Excel中的Name列创建FIFO队列或在此队列中创建最简单的VBA代码每个接受工作的人都会退出队列最后一个人找到工作并增加了她/她的工作数量,将回到第一个人,工作将以同样的方式分配给人们。



例如在约翰之后,艾玛应该找一份工作而在艾玛之后,索菲亚应该找一份工作然后将回到乔接受下一份工作而如果有人不工作,则由于缺勤或拒绝工作而排队如果确认操作员没有工作,请留在队列中。



我尝试过:

<例如,在约翰之后,艾玛应该找一份工作,在艾玛之后,索菲亚应该找一份工作,然后将回到乔接受下一份工作。如果有人不工作,由于缺席而离开队列或拒绝工作并留在qu如果操作员没有工作确认就行了。



我该怎么办?

解决方案

你有在发布问题之前使用谷歌。

我发现了这些:

如何使用Excel创建队列| Chron.com [ ^ ]

如何创建FIFO Excel电子表格Sapling.com [ ^ ]

I have a table like this:

+===========+========================+
| **Name**  |**Number of tasks done**|
+===========+========================+
| joe       |                      1 |
+-----------+------------------------+
| john      |                      1 |
+-----------+------------------------+
| emma      |                      0 |
+-----------+------------------------+
| sophia    |                      0 |
+-----------+------------------------+



I want to make a FIFO queue from Name column in Excel by formula OR simplest VBA code that in this queue Every person who takes a job goes out of the queue and when the last person takes a job and added to the number of her/his jobs, will be back to the first person and the work will be split between the people in the same way.

For example after John, Emma should take a job and after Emma, Sophia should take a job and then will be back to Joe to take next job AND If someone does not work, leave queue due to absence or denial of work and Stay in the queue if the operator is confirmed without work.

What I have tried:

For example after John, Emma should take a job and after Emma, Sophia should take a job and then will be back to Joe to take next job AND If someone does not work, leave queue due to absence or denial of work and Stay in the queue if the operator is confirmed without work.

How can I do that?

解决方案

You have to use Google, before posting a question.
I have found these:
How to Use Excel to Make a Queue | Chron.com[^]
How to Create a FIFO Excel Spreadsheet | Sapling.com[^]


这篇关于如何在excel中使用公式创建FIFO队列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆