Comparing Data with certain criterias

I have a list of customer names, their account numbers, amounts they are paying, and their credit card numbers..

now i need a way to check if a customer has paid more than X number of times, his payment is larger than Y amount, and if the credit card has been used by someone else.
I've made a sample list and attached it.. anyhelp would be greatly appriciated..

bump... anyone got any ideas?

try first , then make some modification

wow,awesome.. thanks sglife.. i think this will do the trick!!