Data validation based on set of column values

[lumjingbki]

I have the below sample data and I want to get update the "Validate" column as output based on group of "shop ID", "Location code","Account" when it is all paid then validate column is "Paid" if the mention group set is in credit then it is credit. can you please provide some suggestions how to go about 

Shop ID	Location code	Account	Paid/Credit	Validate
252	231234	23123433	Paid	Paid
252	231234	23123433	Paid	Paid
252	231234	23123433	Paid	Paid
252	231234	23123433	Paid	Paid
252	231234	23123433	Paid	Paid
252	231234	23123433	Paid	Paid
252	231234	23123433	Paid	Paid
221	321231	23123433	Paid	Paid
221	321231	23123433	Paid	Paid
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
510	345678	23123433	Credit	on credit
221	987654	23123433	Paid	Paid
221	987654	23123433	Paid	Paid
221	987654	23123433	Paid	Paid
221	987654	23123433	Paid	Paid
221	987654	23123433	Paid	Paid
221	987654	23123433	Paid	Paid
221	987654	23123433	Paid	Paid
221	73203	23123433	Credit	on credit
221	73203	23123433	Credit	on credit
221	73203	23123433	Credit	on credit
221	73203	23123433	Credit	on credit
221	73203	23123433	Credit	on credit
221	73203	23123433	Credit	on credit

[alexnajm]

@lumjingbki the data looks like it already does this? Can you clarify what the data is before and what the expected output is?