Comparing updates of a register presented in colums

[Macmoledo]

Hi there,
First my apologies if there is an answer to this already in the forum, but the amount of info is a little overwhelming and I'm taking the quick route; hope you don't mind.
There is a register related to my work that I have to check every week to see whether there are new entries or if one of the existing was dropped.
I download form the web a CSV file that I convert to .XLSX and I keep only the data I need to check; let's say they are projects (the name of the project) and number of assets of that particular project.
Which would be the best way you recommend to compare one week's result with the previous one?
Note that due to the updates, the data for 1 week can be larger or shorter than the one for the following week, i.e. may be a different number of files. Probably obvious but just wanted to make everything clear.
Thanks in advance for any help.
Cheers to all.

 

[Macmoledo]

Hi Toadstool.
Thanks for the explanation; good to know those little shortcuts, probably obvious for everyone in the forum but not for average users I guess.
Regarding the headings I should have noticed that; I was not taking the headings in the range and that's why I wasn't getting it.

By the way and talking about shortcuts, could you recommend me a good post or video here at Mr. Excel to start with Pivot Tables? I'm playing with them and using them occasionally, but just for normal, mostly automatic things, but I know they can be a very powerfull tool and I'd like to go deep into them, but starting from the basics.

Thanks again for all the advice.
Regards.

 

[Toadstool]

Macmoledo,

It's probably best for one of the MrExcel MVPs to give educational recommendations. If one doesn't revisit this thread and see your request then I suggest you make a new thread "Recommendations please for Pivot Tables educational videos?"

Take care,
Toad