Pinned Loading

1. Reconciliation with Python in Excel Reconciliation with Python in Excel

   1

   # خواندن جداول ورودی

   2

   bank = xl("Bank[#All]", headers=True)

   3

   dafater = xl("Dafater[#All]", headers=True)

   4

   5

   # ایجاد ستون جدید با ترکیب مبلغ و تاریخ و شماره گذاری در صورت تکراری بودن

2. Mahmoud Lambda Functions Mahmoud Lambda Functions

   1

   /*

   2

       FUNCTION NAME: J_EOMONTH

   3

       VERSION:1.0

   4

       AUTHOR: Mahmoud Bani Asadi

   5

       WEB: www.arshad-hesabdar.ir

3. M-Functions M-Functions Public

   Custom M functions.

   1

4. UsefulFiles UsefulFiles Public

   This is a place that I will put my useful files that I mention in my training videos.

   Batchfile 2

5. GoogleSheetFunctions GoogleSheetFunctions

   1

   //SplitAmount

   2

   =ArrayFormula(LET(

   3

   z,division,

   4

   count,ROUNDUP(amount/z,),

   5

   a,SCAN(0,count,LAMBDA(x,y,x+y))-count+1,