Hi need your help with the func that return the wrong numbers for part of my cells.
my func :
{=INDEX($C$5:$C$18044,MATCH(MAX(IF($B$5:$B$18044=B6,$E$5:$E$18044)),$E$5:$E$18044,0))}
My Data looks like this:
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
my func :
{=INDEX($C$5:$C$18044,MATCH(MAX(IF($B$5:$B$18044=B6,$E$5:$E$18044)),$E$5:$E$18044,0))}
My Data looks like this:
MailingType | MailingJN | Report Date | MailingDate W/E | Issue Count By Date | date of the highest Issue count |
ADD Inq | M268 | 09/15/2018 | 09/14/2018 | 10/06/2018 | |
ADD Inq | M268 | 09/22/2018 | 09/14/2018 | 4 | 10/06/2018 |
ADD Inq | M268 | 09/29/2018 | 09/14/2018 | 132 | 10/06/2018 |
ADD Inq | M268 | 10/06/2018 | 09/14/2018 | 290 | 10/06/2018 |
ADD Inq | M268 | 10/13/2018 | 09/14/2018 | 148 | 10/06/2018 |
ADD Inq | M268 | 10/20/2018 | 09/14/2018 | 77 | 10/06/2018 |
ADD Inq | M268 | 10/27/2018 | 09/14/2018 | 33 | 10/06/2018 |
ADD Inq | M268 | 11/03/2018 | 09/14/2018 | 18 | 10/06/2018 |
ADD Inq | M268 | 11/10/2018 | 09/14/2018 | 28 | 10/06/2018 |
ADD Inq | M268 | 11/17/2018 | 09/14/2018 | 12 | 10/06/2018 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
JONAI | L529 | 04/21/2018 | 04/20/2018 | 06/23/2018 | 64 | |
JONAI | L529 | 04/28/2018 | 04/20/2018 | 3 | 06/23/2018 | 64 |
JONAI | L529 | 05/05/2018 | 04/20/2018 | 11 | 06/23/2018 | 64 |
JONAI | L529 | 05/12/2018 | 04/20/2018 | 12 | 06/23/2018 | 64 |
JONAI | L529 | 05/19/2018 | 04/20/2018 | 17 | 06/23/2018 | 64 |
JONAI | L529 | 05/26/2018 | 04/20/2018 | 9 | 06/23/2018 | 64 |
JONAI | L529 | 06/02/2018 | 04/20/2018 | 4 | 06/23/2018 | 64 |
JONAI | L529 | 06/09/2018 | 04/20/2018 | - | 06/23/2018 | 64 |
JONAI | L529 | 06/16/2018 | 04/20/2018 | - | 06/23/2018 | 64 |
JONAI | L529 | 06/23/2018 | 04/20/2018 | - | 06/23/2018 | 64 |
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>