Every week, this blog features 5 of the best visualizations from the last week around the web.
Average gas prices in US regions from 1993 plotted in dynamic bar
Flowing data takes a look at the historical gasoline price data and provides us this eye candy.
My friend Jon takes a look at this and recreates it in excel. Read more.[via flowingdata]
Cost of Food around the World
This BBC page provides insights in to changing food price, consumption trends around the world. Scary picture for future generations. [via cool infographics]
Infographic on the Tees, the shirt project
With so many beautiful visualizations, the shirt project is the next natural thing to happen. They spread the story from the charts in a fun way. Go buy one if you like it 🙂
Google Search Insights for search term “excel”
Google has launched search insights which provides excellent detail about various search trends. I have looked up search term excel, and surprisingly India leads the pack with index of 100. Now I know where majority of my audience are 🙂
How the marginal taxes are changing with Obama’s new tax policy
This chart explains how the marginal taxes change with proposed tax structure by Barack Obama. Remember, the key word is marginal (loosely put, since Obama’s tax policies put more money in your pocket, your other taxes will go up) [via marginal revolution]
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.