MS Excel / VBA help thread

You are reading a single comment by @hugo7 and its replies. Click here to read the full conversation.

•

hurricane_run in reply to @hugo7

Power query will make the comparison much easier. Load your tables then Power Pivot the two tables using the appropriate common fields..

•

hugo7 in reply to @hurricane_run

Sounds like I need to get on the YT tutorials then!

•

hurricane_run in reply to @hugo7

I hired a data analyst two years ago who fundamentally changed my understanding of what excel was capable of. I found power query quite intuitive but power pivot more challenging. The real answer to these data questions is to use a direct analysis tool connected to the DB.

About

Avatar for hugo7 @hugo7 started