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..