Forum

new and deleted ent...
 
Notifications
Clear all

new and deleted entries

8 Posts
3 Users
0 Reactions
83 Views
(@sarfrazkhan)
Posts: 30
Trusted Member
Topic starter
 

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.

 
Posted : 12/03/2023 1:41 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Sarfraz

You can use Power Query to do this, as explained in this tutorial.

Mynda

 
Posted : 13/03/2023 12:57 am
(@sarfrazkhan)
Posts: 30
Trusted Member
Topic starter
 

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 ?

 
Posted : 19/03/2023 2:28 pm
(@mynda)
Posts: 4761
Member Admin
 

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.

 
Posted : 19/03/2023 7:28 pm
(@sarfrazkhan)
Posts: 30
Trusted Member
Topic starter
 

Dear Madam,

Can it be from reference number and date and amount all three things can not be the same ?

 
Posted : 25/03/2023 7:37 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Sarfraz,

In that case you can ask Power Query to match 3 columns. See example attached.

Mynda

 
Posted : 25/03/2023 6:53 pm
(@sarfrazkhan)
Posts: 30
Trusted Member
Topic starter
 

hi,

how will I learn power query ?

 
Posted : 26/03/2023 3:22 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi,

With this Power Query course

Regards

Phil

 
Posted : 26/03/2023 7:41 pm
Share: