Hui, one of our in-house excel ninjas at Chandoo.org Forums, has asked an interesting question.
Microsoft is already planning the next version of Excel and is looking for our feedback into what extra chart types it should offer/include. [more]
It is an interesting question, so lets have a poll.
What new chart types you prefer to see next version of excel?
I would love to see box plots, bullet charts and dot plots.
What about you?
Use comments to share your views.
Btw, here are excel tutorials for creating bullet charts, box plots (box plot add-in) and dot plots (add-in).
PS: Only 2 more days before I close the net-book contest.
PPS: Only 3 more days before I close excel school registrations. Sign up today.
PPPS: Only 4 more hours before I shut down the laptop for weekend. Happy weekend 🙂
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.