Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the visualizations featured earlier.
Anatomy of a Great Speech – Obama’s acceptance speech at DNC
Presentation Zen captures Obama’s symphony like acceptance speech in a graph shown above. Do read Garr Reynold’s remarks.
Tracking Hurricane Gustav a la infographic style
These days telling a complex story like how a hurricane strikes is made easy, thanks to tons of flash based visualization tools available for news reporters. [via Flowing Data]
How would tell your story if you are aiming to change a habit? – Google Chrome Comic Book
Google has launched their open source browser Chrome. Now this is a very bold step, when millions of people have developed a hobby of using IE or Firefox and pretty much satisfied with them. How did Google tell their story of new browser and created a need for it ? By creating a comic book and telling every one how browsers work, about memory leaks, garbage collection, UI design. Very effective.
More Olympics visualizations – News paper comes to life and tells impressive stories
What would you do when you are revamping infographics department of a leading news paper? Folks at El Heraldo have done a fantastic job.
Sony Walkman Subway map advertisement
Okay, this is not infographic, but it is a very creative way to tell that Sony Walkman is a constant companion no matter which route you take on the metro. Very creative, very effective. I can’t imagine taking metro to anywhere without company or music. [via cool infographics]
Click here to check out other cool infographics. 🙂
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.