1       111   5/6/13   117     1

 2       111   5/6/13   117     1

 3       111   8/3/14   174     1

 4       111   4/9/13   100     2

 5       111   5/6/13   200     2

 6       111   9/5/14   100     2

 7       222   4/1/13   117     1

 8       222   3/7/13   100     2

 9       333   5/8/13   174     1

10      333   7/4/14   175     1

 

Above is how my report looks and what I want is to create a formula for the Check field that you populate with a yes or not if...

the post dts on the 2 set is equal or greater than the post dts on any of the 1 sets if the num is the same.

So  I want a no to populate in the check field on line 4 because 4/9/13 is not greater than or equal to 5/13/13 or 8/3/14.  I want a yes to populate in the check field on line 5 because 5/6/13 is greater than or equal to 5/6/13.  I want a yes to populate in the check field on line 6 because 9/5/14 is greater than or equal to 5/6/13 and 8/3/14.

Then on to the next batch of same nums line 7 & 8.  A no would populate in the check field because 3/7/13 if not greater than or equal to 4/1/13.

It will be possible for that there is a same num in with a set 1 post dt but no set 2 post dts. Like in lines 9 & 10.  There will not be same nums with a set 2 post dt only.