Krystal

The rationale for keeping/deleting decision is still not obvious. At
first I thought you were probably deleting duplicates, but now that is
clearly not the case as anything that is not duplicated is deleted.
Beyond that, I don't see a pattern. Sometimes you only have one, but
you can delete 2, so you delete it. In one case you have 5 can delete
4, so you keep only the last one. In another case you have 4 but you
can delete 7 so you delete them all. In another case you have 3, can
delete 1, so you delete only the last one. In another case you have
4, you can delete 2, so you keep only the last 2. I don't see how you
can tell how many you can delete; and, then when given how many can be
deleted, I don't see how you decide which ones to delete.

Ken

On Oct 12, 3:04*pm, Krystal Peters
wrote:
For (2) Col A does not increment as they are acct #'s; Col B let me know the
maximum # of rows I can delete. *Below I showed in a third col what i would
like to happen...

SAMPLE DATA:

ACCT_NO * *Requests Found * * * action to take
289278995 * * * * * *1 * * * * * * * * * * * * *delete
289278999 * * 1 * * * * * * * * * * * * *keep
289278999 * * 1 * * * * * * * * * * * * *keep
289278999 * * 1 * * * * * * * * * * * * *delete
870587008 * * * * * *1 * * * * * * * * * * * * *delete
119387014 * * * * * *1 * * * * * * * * * * * * *delete
158675527 * * 2 * * * * * * * * * * * * *delete
654375649 * * 2 * * * * * * * * * * * * *delete
569777245 * * 2 * * * * * * * * * * * * *delete
752478468 * * 2 * * * * * * * * * * * * *delete
752478468 * * 2 * * * * * * * * * * * * *delete
396378512 * * 2 * * * * * * * * * * * * *delete
396378512 * * 2 * * * * * * * * * * * * *delete
396378512 * * 2 * * * * * * * * * * * * *keep * *
396378512 * * 2 * * * * * * * * * * * * *keep
399778090 * * 3 * * * * * * * * * * * * *delete *
399778090 * * 3 * * * * * * * * * * * * *delete *
399778090 * * 3 * * * * * * * * * * * * *delete *
208777882 * * 4 * * * * * * * * * * * * *delete *
208777882 * * 4 * * * * * * * * * * * * *delete *
208777882 * * 4 * * * * * * * * * * * * *delete *
208777882 * * 4 * * * * * * * * * * * * delete *
208777882 * * 4 * * * * * * * * * * * * keep
987178737 * * 4 * * * * * * * * * * * * delete *
987178737 * * 4 * * * * * * * * * * * * *delete *
117468837 * * 7 * * * * * * * * * * * * delete *
117468837 * * 7 * * * * * * * * * * * * delete *
117468837 * * 7 * * * * * * * * * * * * delete *
117468837 * * 7 * * * * * * * * * * * *delete * *