Good morning,
I'm looking back a couple years in payment history and trying to pull the number of people who originally paid with a discount and then paid full price the next payment they made.
Sample date
[TABLE="width: 800"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Account[/TD]
[TD]Name[/TD]
[TD]Old Exp[/TD]
[TD]New Exp[/TD]
[TD]Pay From[/TD]
[TD]Discount[/TD]
[TD]Payment [/TD]
[TD]Publication[/TD]
[/TR]
[TR]
[TD]10/3/2008[/TD]
[TD]2[/TD]
[TD]Bob Man[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="class: xl63, width: 88, align: right"]9/28/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]12/29/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86, align: right"]9/29/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]YZK[/TD]
[/TR]
[TR]
[TD]10/3/2008[/TD]
[TD]45[/TD]
[TD]Chris Man[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="class: xl65, width: 88, align: right"]10/22/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]1/22/2009[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86, align: right"]10/22/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]YZK[/TD]
[/TR]
[TR]
[TD]10/3/2008[/TD]
[TD]3333[/TD]
[TD]Chris Mans[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="class: xl65, width: 88, align: right"]10/23/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]1/23/2009[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86, align: right"]10/23/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]YZK[/TD]
[/TR]
</tbody>[/TABLE]
Some more information about the data set I have.
Dates range from 10/3/2008 until today, Names are unimportant, Discount and Payment can both be zero, there are 13 different publication codes.
I'm looking back a couple years in payment history and trying to pull the number of people who originally paid with a discount and then paid full price the next payment they made.
Sample date
[TABLE="width: 800"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Account[/TD]
[TD]Name[/TD]
[TD]Old Exp[/TD]
[TD]New Exp[/TD]
[TD]Pay From[/TD]
[TD]Discount[/TD]
[TD]Payment [/TD]
[TD]Publication[/TD]
[/TR]
[TR]
[TD]10/3/2008[/TD]
[TD]2[/TD]
[TD]Bob Man[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="class: xl63, width: 88, align: right"]9/28/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]12/29/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86, align: right"]9/29/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]YZK[/TD]
[/TR]
[TR]
[TD]10/3/2008[/TD]
[TD]45[/TD]
[TD]Chris Man[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="class: xl65, width: 88, align: right"]10/22/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]1/22/2009[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86, align: right"]10/22/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]YZK[/TD]
[/TR]
[TR]
[TD]10/3/2008[/TD]
[TD]3333[/TD]
[TD]Chris Mans[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="class: xl65, width: 88, align: right"]10/23/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD="class: xl65, width: 80, align: right"]1/23/2009[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86, align: right"]10/23/2008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]YZK[/TD]
[/TR]
</tbody>[/TABLE]
Some more information about the data set I have.
Dates range from 10/3/2008 until today, Names are unimportant, Discount and Payment can both be zero, there are 13 different publication codes.