I've attached a sample of a spreadsheet I've put together to determine which location owes which money pulled from a much more extensive spreadsheet with a lot of extra data...
So in it's simplest form, it shows where a card was redeemed and for how much as well as which store issued the card originally.
I am looking to build a sheet that will break down if a card was purchased at store "md" but was redeemed at store "cr" then store "md" owes store "cr" for the redemption.
I've broken down the gross amounts to be distributed but am having trouble determining how to pull the data for the detail taking into account that many cards were purchased and redeemed at the same location requiring no action on my part.
Let me know if anyone has any suggestions.