Good Day All
I have a workbook with five sheets (each of them a rental store name) and a sixth one (return store).
Each of the sheets is set up the same way: Column A - Date, Column B - Last Name, Column C- First Name, Column D - S shirt, Column E - M Shirt, Column F - L Shirt, Column G - Time of rental.
The "Return Store" sheet is set-up the same but is fro returns.
What would be the best way / formula to count the liability (number of shirts not returned) across the five stores if I set up a seventh sheet (Liability)? What I need is to see, if Mr. X has rented 2 shirts of each size in 2 stores but has returned only one of each, then how many shirts are still with Mr. X.
Thank you in advance for your input.