Planning activities on difrent daye - but two only

tenbellies

New Member
Joined
May 8, 2018
Messages
6
Hi all,

I have a large spreadsheet with a seris of activites on the majority can be done the same day, however further down the process we can only do two each day.

So is there a formula that anyone knows that looks at a row of dates and then only allocates two activities on any one weekday, so it would look like this?

01/10/18
02/10/18
01/10/18
02/10/18
01/10/18
03/10/18
01/10/18
03/10/18
02/10/18
04/10/18
02/10/18
04/10/18
03/10/18
05/10/18
04/10/18
05/10/18
04/10/18
08/10/18
04/10/18
08/10/18

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Oscar Cronquist

Board Regular
Joined
Apr 20, 2018
Messages
200
A
B
C
D
1
Dates1Dates2Dates 2
2
1/10/2018​
2/10/2018​
8/10/2018​
3
1/10/2018​
2/10/2018​
8/10/2018​
4
1/10/2018​
3/10/2018​
5/10/2018​
5
1/10/2018​
3/10/2018​
2/10/2018​
6
2/10/2018​
4/10/2018​
2/10/2018​
7
2/10/2018​
4/10/2018​
4/10/2018​
8
3/10/2018​
5/10/2018​
3/10/2018​
9
4/10/2018​
5/10/2018​
4/10/2018​
10
4/10/2018​
8/10/2018​
3/10/2018​
11
4/10/2018​
8/10/2018​
5/10/2018​
Sheet: Sheet63

Array formula in cell B2:

=MIN(IF((COUNTIF($B$1:B1,$D$2:$D$11)<2)*(COUNTIF($D$2:$D$11,$D$2:$D$11)>COUNTIF($B$1:B1,$D$2:$D$11)),$D$2:$D$11,""))

Press and hold CTRL + SHIFT and then press Enter to create an array formula.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,621
Messages
5,523,947
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top