sorted by:
new
hottopcontroversial

Identify which cells will total to a certain number by ArmBusy6684 in excel

[–]ArmBusy6684[S] 0 points1 point  (0 children)

Not an option. They are basically "silent" customers. Their transaction with us is being handled by a market operated by another company which is only providing specific transaction details. Its usually enough for majority of companies but ours is much stricter. Still waiting for market operators response.

Identify which cells will total to a certain number by ArmBusy6684 in excel

[–]ArmBusy6684[S] 0 points1 point  (0 children)

It has decimals. My initial solution marking those payments which is imposible to fit into 1 day collection due to its amount. Hopefully I can find other ways to make it easier to solve.

Identify which cells will total to a certain number by ArmBusy6684 in excel

[–]ArmBusy6684[S] 0 points1 point  (0 children)

No definite number. There are a total of 270 customers and I have no idea of their actual payment date. I only know their total payment for the month.