Filtering by unique identifiers while perfoming function

[txdude311]

Hello I need some help:[FONT=&quot][/FONT]

I have a spread sheet with dozens of thousands of unique identifies (Subscriber IDs). Each one represents a person.

Some people were billed for a coverage periods and some people's billing for a coverage period was skipped.

Now I have to figure out which people need to be billed for the because previous coverage periods were not billed, according to the current months record (July).

EXAMPLE:


NOTE:
Red shows the discrepancy that a person needs to be billed for
Green represents the journal entry and billing coverage period accounting for each other and not bill needs to be issued.

ADRI's coverage period from 2/1 - 2/29 was billed in June.

June's bill that covered 2/1 - 2/29 coverage period has a July journal entry for said coverage period.

However, the coverage period from 1/1 - 1/31, has a July journal entry, but no 1/1 - 1/31 billing month.

Therefore, ADRI, needs to be billed for coverage period, the 1/1-131.

HERE ARE THE VALUES:

[FONT=&quot]Group ID[/FONT]	[FONT=&quot]Subscriber ID[/FONT]	[FONT=&quot]Last Name[/FONT]	[FONT=&quot]First Name[/FONT]	[FONT=&quot]Coverage Period Start[/FONT]	[FONT=&quot]Coverage Period End[/FONT]	[FONT=&quot]Bill[/FONT]	[FONT=&quot]Bill[/FONT]	[FONT=&quot]Journal Entry[/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]Charge or No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]2225836554​ [/FONT]​	[FONT=&quot]SHUNS[/FONT]	[FONT=&quot]ANGI[/FONT]	[FONT=&quot]1/1/2016​ [/FONT]​	[FONT=&quot]1/31/2016​ [/FONT]​	[FONT=&quot]May[/FONT]			[FONT=&quot]$ 221.91[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]2225836554​ [/FONT]​	[FONT=&quot]SHUNS[/FONT]	[FONT=&quot]ANGI[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot]June[/FONT]		[FONT=&quot]$ 776.53[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]2225836554​ [/FONT]​	[FONT=&quot]SHUNS[/FONT]	[FONT=&quot]ANGI[/FONT]	[FONT=&quot]1/1/2016​ [/FONT]​	[FONT=&quot]1/31/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 758.37[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]2225836554​ [/FONT]​	[FONT=&quot]SHUNS[/FONT]	[FONT=&quot]ANGI[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 245.70[/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]3522559283​ [/FONT]​	[FONT=&quot]TOTT[/FONT]	[FONT=&quot]TORI[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​		[FONT=&quot]June[/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]$ 336.84[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]3522559283​ [/FONT]​	[FONT=&quot]TOTT[/FONT]	[FONT=&quot]TORI[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 306.74[/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6833582290​ [/FONT]​	[FONT=&quot]SANCH[/FONT]	[FONT=&quot]ADRI[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot]June[/FONT]		[FONT=&quot]$ 269.71[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6833582290​ [/FONT]​	[FONT=&quot]SANCH[/FONT]	[FONT=&quot]ADRI[/FONT]	[FONT=&quot]1/1/2016​ [/FONT]​	[FONT=&quot]1/31/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 770.69[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6833582290​ [/FONT]​	[FONT=&quot]SANCH[/FONT]	[FONT=&quot]ADRI[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 950.93[/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]Charge [/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6580150312​ [/FONT]​	[FONT=&quot]VIKOOD[/FONT]	[FONT=&quot]SKLER[/FONT]	[FONT=&quot]1/1/2016​ [/FONT]​	[FONT=&quot]1/31/2016​ [/FONT]​	[FONT=&quot]May[/FONT]			[FONT=&quot]$ 209.49[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6580150312​ [/FONT]​	[FONT=&quot]VIKOOD[/FONT]	[FONT=&quot]SKLER[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot]June[/FONT]		[FONT=&quot]$ 518.66[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6580150312​ [/FONT]​	[FONT=&quot]VIKOOD[/FONT]	[FONT=&quot]SKLER[/FONT]	[FONT=&quot]1/1/2016​ [/FONT]​	[FONT=&quot]1/31/2016​ [/FONT]​	[FONT=&quot] [/FONT]	[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 744.44[/FONT]		[FONT=&quot]No Charge[/FONT]
[FONT=&quot]POD-11-KP\[/FONT]	[FONT=&quot]6580150312​ [/FONT]​	[FONT=&quot]VIKOOD[/FONT]	[FONT=&quot]SKLER[/FONT]	[FONT=&quot]2/1/2016​ [/FONT]​	[FONT=&quot]2/29/2016​ [/FONT]​		[FONT=&quot] [/FONT]	[FONT=&quot]July[/FONT]	[FONT=&quot]$ 209.49[/FONT]		[FONT=&quot]No Charge[/FONT]

<tbody>
</tbody>