I have a sheet of creditors and there is a checkbox on each entry next to total price column. When I receive the payment I check the checkbox. Now I am trying to query all the unpaid creditors to another sheet but I don't know how to query creditor name when the checkbox is on another row. I can query same row entries. here is how it looks like

I tried QUERY. But didn't help. It just shows same row items. What happens here is first column customers buy the items on second column and if customer pays then third column becomes TRUE and if it is a credit, then it is FALSE. And if customer buys more than 1 item, then the TRUE value will be next to the last item of second column. So what I am trying to achieve is, I am trying to query or whatever somehow filter those customers who haven't paid their payment. –

CodePudding user response：

It would be better if the table is formatted in