Compare Multiple Lists with a Pivot Table
HTML-код
- Опубликовано: 8 июл 2024
- www.excelcampus.com/pivot-tabl...
Learn how to create a simple report to compare two or more lists of data with a pivot table. This pivot table technique is very fast and easy to implement and does NOT require any complex formulas. Download the workbook to follow along.
www.excelcampus.com/newsletter/ 
Хобби
What a fantastic tip, Jon, Thank you very much! This week it saved a lot of time when I had to compare which companies operated during three years or only the last two. What a great advantage of pivot table!
Very helpful, I didn't even know where to start in comparing billable hours from year to year, and this helped me get started.
Wow, i was looking for smth like this for the whole week and made it so easy for me. Thank you very much :)
Jon, you are doing a great job! Thank you so much!!!
So very well explained. Thank you for sharing your knowledge and expertise.
Excellent tutorial. Thank you so much!
What a cool way! Thanks Jon for the great tutorial.
*Smashes that Like button* Was trying to use calculations to make comparisons, but this Pivot Table technique was a far more appropriate fit for the data I was looking at, and a million times easier. Thank you for this video.
Thank you for making this so simplistic. This is by far the best example of creating a Pivot Table I've seen. Amazing!!! Thanks again. Now my supervisor can get off my back for something I did not know how to do.
Thank you for your feedback, Retta! 😀
@@ExcelCampus You're welcome.
Easy to follow, very helpful. Thanks!
MANY THANKS TO YOU JON.
you are great Jon! thanks for the videos
Excellent tutorial Thank You
Great video on Pivot Tables using a practical example to learn easier.
Thank you for the great and precise explanation
You really nailed it!! Thank you so much!!!
Love the shortcuts, easy to understand-going to watch the rest of your posts-thanks very much!
Thanks! I'm glad to hear you enjoyed it. :-)
Thanks Jon..it helps me a lot.
You nailed it! Thanks :-)
Your videos are great even your tutorials. I hope that you would make a success in your future. Thanks Excel Campus Jon
Thanks. You are a star!
Excellent tutorial
Thanks so much. Exactly what I needed.
Thanks for the help!
Thanks so much I learned a lot from this.
Thank you very much for your videos. Learned a lot!!I followed your 3 videos and created 1st dashboard with slicers and connections ! Thank you very much to you!. Every week, I need to add more data, but I have troubles how to refresh the pivot charts. Some tips would be greatly appreciated.
I love it. I subscribed
Thanks a lot for the info. provided in this video.
Feel easy to understand! thanks Jon
+Niloy Sadat Thanks Niloy!
great info!
Amazingly taught !!!
+Santosh Poojary Thanks Santosh!
sir, very nice i like it too much the idea for maintaining the data at a single place.
very useful thank u Pivot Table
Thank you so munch
nice info..
good for learning
Cool. Thanks
Useful? Yes very much!
How do you compare two numeric columns from different sheets to spot the mismatch using pivot table or any other excel functions?
How do I compare, compile two non indexed lists A & B in excel for the best match, I do not know which is the word or partial string, which need to search as criteria in second list. The computer to take out the best match word or a string out in column C. Tx
Nice