Formula For Consolidation

kme

New member
Joined
Jul 9, 2024
Messages
3
Reaction score
0
Points
1
Excel Version(s)
321321321
Cross-posted here: https://chandoo.org/forum/threads/consolidation-excel-summary-formula.57989/

Excel Formula

1.1st Sheet Outstanding Bills of a customer dealing with a different branch of a group.
2. Different Branches are Dealing With Same Customer
3. Sample Answer Format are Given Sheet-2 "Sample-Answer"
4. Answer required Sheet-3 "Answer" through Formula.
5. Customer Balance and Ageing Data Required Based On Branch Code
6.By doing a Customer Different Branch Deal. Account Credit Days & Limit .In case of same customer, just Came Account Credit Days & Limit against a 1 branch .

Attachments​

 

Attachments

  • Outstanding Bills..xlsx
    23.7 KB · Views: 0
Last edited by a moderator:
Sorry Sir. Kindly allow the answer
 
Back
Top