I have a column of 57 purchases and a column of 18 payments. Is there a way to look up which purchases total a certain amount? Example would be if I had purchases of $10, $15, and $1 in column A, and one of the payments was $26 in column B, it would be identified?
I've tried pivot tables and a variety of formulas and nothing has worked.
Aucun commentaire:
Enregistrer un commentaire