Enter data into column based in time interval in adjacent column

[David Kirker]

My goal is to create a schedule using the fewest number of people as possible while maintaining a minimum interval between procedures. I start by adding the letter ‘A’ in the f.name column and continue until I see an interval in the time column that is less than desired (3 to 5 min, depending). I will add subsequent letters (B, C, D, E, etc.) as needed but always default to the first letters where possible. I then resort by f.name and time to create shifts for actual people. I am happy to pay for this code but my first question is. CAN THIS BE DONE? Second, what might this code look like? I have limited experience with VBA but no longer have time to research the code. Any help is greatly appreciated. I'm using excel 2013 on Office 365. I expect the upgrade to 2016 soon.
This is the sheet I use:
[TABLE="width: 506"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]NUM[/TD]
[TD]INT[/TD]
[TD]T.S.[/TD]
[TD]PROCEDURE[/TD]
[TD]T.P.[/TD]
[TD]TIME[/TD]
[TD]F.NAME[/TD]
[TD]L.NAME[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:15[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:22[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:29[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]06:30[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:06[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:36[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]06:37[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:06[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:43[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]06:44[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]06:45[/TD]
[TD]C[/TD]
[TD] [/TD]
[TD="align: right"]00:05[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:50[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]06:51[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]06:52[/TD]
[TD]C[/TD]
[TD] [/TD]
[TD="align: right"]00:05[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:57[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]06:58[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]06:59[/TD]
[TD]C[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:00[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]07:04[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]07:05[/TD]
[TD]C[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]07:06[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:07[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]9[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]07:11[/TD]
[TD]C[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]07:12[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]07:13[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:14[/TD]
[TD]C[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]07:18[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]07:19[/TD]
[TD]B[/TD]
[TD] [/TD]
[TD="align: right"]00:01[/TD]
[/TR]
</tbody>[/TABLE]

This is the product, where I have failed to meet the minimum interval:

[TABLE="width: 585"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]NUM[/TD]
[TD]INT[/TD]
[TD]T.S.[/TD]
[TD]PROCEDURE[/TD]
[TD]T.P.[/TD]
[TD]TIME[/TD]
[TD]F.NAME[/TD]
[TD]L.NAME[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:15[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:22[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:29[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:36[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:43[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:50[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:07[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]06:57[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:00[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:06[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]07:06[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:06[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]07:12[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:06[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]07:18[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:21[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:06[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]07:27[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:05[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]12[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]07:32[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:35[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:05[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]11[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.5 HR[/TD]
[TD]07:40[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1.5 HR[/TD]
[TD]07:44[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.75 HR[/TD]
[TD]07:48[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:05[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]15[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]07:53[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]9[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]07:56[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]BC (1 Tube)[/TD]
[TD]2 HR[/TD]
[TD]08:00[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]08:03[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]BC (1 Tube)[/TD]
[TD]2 HR[/TD]
[TD]08:07[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]11[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]08:10[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]BC (1 Tube)[/TD]
[TD]2 HR[/TD]
[TD]08:14[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]12[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]08:17[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]08:21[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:03[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]13[/TD]
[TD]BC (1 Tube)[/TD]
[TD]1 HR[/TD]
[TD]08:24[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:04[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]20[/TD]
[TD]BC (1 Tube)[/TD]
[TD]0.25 HR[/TD]
[TD]08:28[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD="align: right"]00:02[/TD]
[/TR]
</tbody>[/TABLE]

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Time[/td][td]Name[/td][td]Interval[/td][td][/td][td]Names[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

6:15​

[/td][td]A[/td][td][/td][td][/td][td]A[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

6:22​

[/td][td]A[/td][td][/td][td][/td][td]B[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

6:29​

[/td][td]A[/td][td][/td][td][/td][td]C[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

6:30​

[/td][td]B[/td][td][/td][td][/td][td]D[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

6:36​

[/td][td]A[/td][td][/td][td][/td][td]E[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

6:37​

[/td][td]B[/td][td][/td][td][/td][td]F[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

6:43​

[/td][td]A[/td][td][/td][td][/td][td]G[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

6:44​

[/td][td]B[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

6:45​

[/td][td]C[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

6:50​

[/td][td]A[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

6:51​

[/td][td]B[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

6:52​

[/td][td]C[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]

6:57​

[/td][td]A[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td]

6:58​

[/td][td]B[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td]

6:59​

[/td][td]C[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td]

7:00​

[/td][td]D[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

18​

[/td][td]

7:04​

[/td][td]A[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

19​

[/td][td]

7:05​

[/td][td]B[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

20​

[/td][td]

7:06​

[/td][td]C[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

21​

[/td][td]

7:07​

[/td][td]D[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

22​

[/td][td]

7:11​

[/td][td]A[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

23​

[/td][td]

7:12​

[/td][td]B[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

24​

[/td][td]

7:13​

[/td][td]C[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

25​

[/td][td]

7:14​

[/td][td]D[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

26​

[/td][td]

7:18​

[/td][td]A[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

27​

[/td][td]

7:19​

[/td][td]B[/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet3[/td][/tr][/table]

I entered A in cell B2.

The following array formula seems to work.
Array formula in cell B3:
=INDEX($E$2:$E$8,MATCH(0,FREQUENCY(IF(A3-$A$2:A2<=(5/1440),MATCH($B$2:B2,$E$2:$E$8,0),99999),MATCH($E$2:$E$8,$E$2:$E$8,0)),0))

How to enter an array formula
1. Double click on cell B3
2. Copy / Paste formula to cell B3
3. Press and hold CTRL + SHIFT
4. Press Enter