Finally the wait is over. Here are the winners of our 2014 dashboard contest.
Consolation prize winner – Thiruselvan
Originally, I had planned to give only 3 prizes. But the sheer number of brilliant entries forced me to add one more prize. The 4th prize goes to Thiruselvan. He will get a choice of 3 Excel books from Amazon.
3rd Prize winner – Arnaud Duigou
Arnaud’s dashboard was ranked highly by both our judges & loved by you as well. He will receive a Samsung Galaxy Tab 3 (valued at $199) very soon.
2nd Prize winner – David Hoppe
David’s smartly designed dashboard is well appreciated by our judges and you. And thus he gets an iPad Mini (16GB), valued at $399.
First prize winner – Roberto Mensa
Well, when you have Roberto Mensa, the Messi of Excel charting world, the Roger Federer of visualization competing in a contest, you know what to expect. Roberto’s clever visualization, expert use of powerful Excel techniques has won our hearts and votes. He gets an iPad Air (16 GB), valued at $499 very soon.
Highly commendable entries
Apart from these 4, 8 more dashboards deserve lots of praise. You can easily learn dozens of Excel tricks, charting techniques and get loads of inspiration by observing the work of,
Jean-MarcVoyer, Matthew Waechter, Jon Schwabish, Michael Bellot, Srinivas Chilukuri, Niyaz Shaffi, Stacey Baker & Mark Weber.
Thank you.
Thank you so much for participating
Everyone who participated in this contest deserves appreciation. It is not an easy task to carve out a dashboard (or set of charts) from raw data like this. You are truly awesome for taking the first step.
Special thanks to our judges Jordan & Hui. Your valuable time & feedback is really appreciated.
Congratulate the winners
If you enjoyed this contest, say congratulations to the winners & other participants. 🙂
PS: Explore all the 49 dashboards & learn something new.
PPS: And just in case you missed the fireworks, you can see them in Excel.
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.