Mere pass excel ke 2 sheet hai jisme sundry debtors ke name hai lgvg 20000 party ke aaspass honge aur dono sheet me party name me kuch na kuch spelling mistakes hai. example ke liye
1st sheet me (Jagdamba Falam Traders Pvt. Ltd) hai aur 2nd sheet me (Jagadamba Phalam Traders pvt. Ltd hai)
aise hi 80% party ke case me hai to mjhe ab formulas lgana hai dono ke closing balance check krne ke liye to mai ese ab kaise kru
Menu
Excel sheet for formulas or function
Replies (6)
Quick Summary
Take help from Auditors and pass journal entries for rectification
Just sort the name from alphabet and match
Excel may be corrected . Is it happened in accounting software also ?
#ca rashmi gandhi mam mujhe ye jaana hai ca club of india ke team se ki eska koi other option ni hai jisse work pura simple ho jaye jaise ki formulas work krta hai work ko simple krne me
U can use pivot table help data will be filtered and from there you sum up similar names
Send me i will do it for you, no other option.
Recent Topics :
- Police Bandobost and GST Invoice
- Understanding where manual effort goes in audit wo
- Scanned purchase bills to Tally XML with GST check
- TDS applicability of foreign remittance to Oracle
- GSTR 9 LATE FEE
- Best Online Mock Test Series for CA Inter January
- COST OF IMPROVEMENT
- Pillows and Mattresses
- GST Applicability for Reg. / Un-Reg. Indian custom
- Amended GST Act & Rules
Related Topics :
CAclubindia
