In the 49th session of Chandoo.org podcast, let’s talk about data dumps!
What is in this session?
In this podcast,
- What is a data dump
- Examples of data dump
- Why we dump
- Ways to avoid data dumps
- Go for information dumps
- Sort the dump
- Filter the dump
- Give a table
- Resources for you
Listen to this session
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Click here to download the MP3 file.
Resources for making animated charts
Making better charts in Excel:
Charting podcasts:
- CP029 – Impress your boss with awesome charts – 6 step road map
- CP032 – Rules for creating legendary column charts
- CP038 – Data to Ink Ratio – What is it and how to optimize it
Transcript of this session:
Download this podcast transcript [PDF]
Come across any data dumps? Share your story…
Now it’s your turn. Do you come across any data dumps in your line work? Share the story in the comments section.
Dump some love – Review my podcast
If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes.
Also, do dump this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.