Dear Madam,
I have two sheets sheet1 old and sheet2 new.
on daily basis It takes my time to find different entries from both sheets and applying lookup for remark.
Can you please me to fix daily working using.
I wanted just to generate ledger from my software and excel should tell me difference entries.
Dear Madam,
Thanks for your reply.
Its not working because somewhere reference numbers are same.
Also without power query its not possible?
No formula in excel to solve the problems without power query ?
If the reference numbers are the same, then what is the logic to tell the transactions apart? Please provide examples based on your file so I can follow.
Dear Madam,
Can it be from reference number and date and amount all three things can not be the same ?
Hi Sarfraz,
In that case you can ask Power Query to match 3 columns. See example attached.
Mynda
hi,
how will I learn power query ?