Formula to numbering with terms

[Wojciech]

I am asking for help in creating a formula that will give the results in the yellow box in cells D2 to O12 in the attached table.


Description of the formula:
1. In column "A" "TYPE NUMBER" there are 3 different digits (target n-digits) and, for example: for "TYPE NUMBER" with the value "1" (in cells: A7, A11, A12) in column C "SEQUENCE NUMBER" digits exist: 6, 8 and 1 (in cells: B7, B11, B12). The formula should rank the numbers from the smallest to the largest, i.e. assign them the numbering:
6-> 2
8-> 3
1-> 1


2. In addition, the formula should, due to the date in column "C" "MONTH OF STOP OF NUMBERING" compared with one of the cells D1: O1 stop counting the row in the next month after "MONTH OF STOP OF NUMBERING".


Examples:
a) From "TYPE NUMBER" in column "A" with the value "1" the formula calculates the following order: D12 = 1, D7 = 2, D11 = 3
b) From the "TYPE NUMBER" column "A" with the value "2", the formula calculates the following order: D5 = 1
c) From "TYPE NUMBER" in the column "A" with the value "3", the formula calculates the following order: D3 = 1, D9 = 2
d) Because "MONTH OF STOP OF NUMBERING" in cell C12 is February, the formula ends numbering in February in cell E12. Because this is the first occurrence of "TYPE NUMBER" and "SEQUENCE NUMBER", therefore in D12 = 1 and E12 = 1.
e) In C7 there is no "MONTH OF STOP OF NUMBERING", so the numbering is displayed in this row until December D7: O7, but since March (F7) this is the first occurrence of "TYPE NUMBER" = 1 (no value in F12 : O12), then the value 1 in F7: O7 is displayed.
f) analogy, eg in D11: E11 = 3, because this is the third occurrence of "TYPE NUMBER" 1 in January and February, and from March to November it is the second occurrence (F11: N11). In December, nothing appears in O11 because the date in C11 (November date) ends the numbering in November.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	TYPE NUMER	SEQUENCE NUMBER	MONTH OF STOP OF NUMBERING	2018-01-31	2018-02-28	2018-03-31	2018-04-30	2018-05-31	2018-06-30	2018-07-31	2018-08-31	2018-09-30	2018-10-31	2018-11-30	2018-12-31
2
3	3	2	2018-08-20	1	1	1	1	1	1	1	1
4
5	2	22	2018-06-12	1	1	1	1	1	1
6
7	1	6		2	2	1	1	1	1	1	1	1	1	1	1
8
9	3	10	2018-01-05	2
10
11	1	8	2018-11-05	3	3	2	2	2	2	2	2	2	2	2
12	1	1	2018-02-15	1	1
Sheet

I'm sorry if I made mistakes in English.

 

[Eric W]

Try this in D2:

=IF($A2="","",IF(OR($C2="",EOMONTH($C2,0)>=D$1),SUMPRODUCT(--($A$2:$A$12=$A2),(($C$2:$C$12>EOMONTH(D$1,-1))+($C$2:$C$12="")),--($B$2:$B$12<$B2))+1,""))

Change the ranges to match your sheet. Copy down and to the right as needed.

 

[Wojciech]

Thank you Eric. I have a problem with the formula. I do not know why an error occur in cells D7:O7 and incorrect results in D11:N11 :


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:124px;" /><col style="width:124px;" /><col style="width:124px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /><col style="width:111px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td></tr><tr style="height:65px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#d9d9d9; font-weight:bold; font-family:Arial; text-align:center; ">TYPE NUMER</td><td style="background-color:#d9d9d9; font-weight:bold; font-family:Arial; text-align:center; ">SEQUENCE NUMBER</td><td style="background-color:#d9d9d9; font-weight:bold; font-family:Arial; text-align:center; ">MONTH OF STOP OF NUMBERING</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-01-31</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-02-28</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-03-31</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-04-30</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-05-31</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-06-30</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-07-31</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-08-31</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-09-30</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-10-31</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-11-30</td><td style="background-color:#d9d9d9; font-family:Arial; text-align:center; ">2018-12-31</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-family:Arial; text-align:center; ">3</td><td style="font-family:Arial; text-align:center; ">2</td><td style="font-family:Arial; text-align:center; ">2018-08-20</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:Arial; text-align:center; ">2</td><td style="font-family:Arial; text-align:center; ">22</td><td style="font-family:Arial; text-align:center; ">2018-06-12</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:Arial; text-align:center; ">1</td><td style="font-family:Arial; text-align:center; ">6</td><td style="font-family:Arial; "> </td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td><td style="background-color:#ff9966; font-family:Arial; ">#ARG!</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:Arial; text-align:center; ">3</td><td style="font-family:Arial; text-align:center; ">10</td><td style="font-family:Arial; text-align:center; ">2018-01-05</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">2</td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:Arial; text-align:center; ">1</td><td style="font-family:Arial; text-align:center; ">8</td><td style="font-family:Arial; text-align:center; ">2018-11-05</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">4</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">4</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ff9966; font-family:Arial; text-align:center; ">3</td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:Arial; text-align:center; ">1</td><td style="font-family:Arial; text-align:center; ">1</td><td style="font-family:Arial; text-align:center; ">2018-02-15</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; text-align:center; ">1</td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td><td style="background-color:#ffff00; font-family:Arial; "> </td></tr></table>


Maybe some influence is that I use the Polish version of Excel 2013 and that I had to translate the formula.

=JEŻELI($A2="";"";JEŻELI(LUB($C2="";NR.SER.OST.DN.MIES($C2;0)>=D$1);SUMA.ILOCZYNÓW(--($A$2:$A$12=$A2);(($C$2:$C$12>NR.SER.OST.DN.MIES(D$1;-1))+($C$2:$C$12=""));--($B$2:$B$12<$B2))+1;""))

I changed only:

,->;
IF->JEŻELI
OR->LUB
EOMONTH->NR.SER.OST.DN.MIES
SUMPRODUCT->SUMA.ILOCZYNÓW

 

[Wojciech]

#ARG ! is a #REF ! error.

 

[Eric W]

I'm not sure how else to help. Here's my test sheet:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]TYPE NUMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]SEQUENCE NUMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]MONTH OF STOP OF NUMBERING[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1/31/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]2/28/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]3/31/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]4/30/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]5/31/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]6/30/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]7/31/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]8/31/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]9/30/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]10/31/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]11/30/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]12/31/2018[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]8/20/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]22[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]6/12/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]1/5/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]11/5/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"]2/15/2018[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet7​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF($A2="","",IF(OR($C2="",EOMONTH($C2,0)>=D$1),SUMPRODUCT(--($A$2:$A$12=$A2),(($C$2:$C$12>EOMONTH(D$1,-1))+($C$2:$C$12="")),--($B$2:$B$12<$B2))+1,""))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



As you can see, I get the same results as your sample in post # 1.

It's conceivable that the translation could cause a problem, but I can't help much there, since I don't speak Polish. There is a translation tool:

https://en.excel-translator.de/translator/

but it returns the exact formula you posted. If I think of something, I'll let you know. Maybe someone else can help.

 

[Wojciech]

Thank you again Eric. I think that shortcuts in Polish Excel work differently or there is some mistake in "translating / implementing formulas". I guess it is a waste of time to look for a reason, because I found a solution to the problem - in column C, instead of empty cells, the formula displays a very distant date for me, for example, year 3000-01-01.