In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.
What is in this session?
This session has 2 things.
- A surprise Easter egg (an Excel tip hidden in the podcast audio)
- Collection of Excel tips recorded & submitted by Chandoo.org readers
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Keyboard & Mouse shortcuts
Chart formatting tips:
Transcript of this session:
Download this podcast transcript [PDF]
Did you find the Easter egg?
Now that you found the Easter egg, it is your turn. Go ahead and leave a comment with cryptic message. Share your favorite Excel tip or ideas with us.
Thanks to the contributors
Many many thanks to both Roberts, Micky, TJ, Val & Orkun. It was fun learning from you.
2 Responses to “Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org”
How did you arrive or formula when you ask me who made more sales Jackie or Jamie?? I could not figure the formula out yet??
@Frank
You need to sum up the sales for Jackie and compare them to the sales of Jamie over the same period.
The practical parts depends on how and what data you have and how it is arranged.
But it will either involve a Sum, Sumif, Sumifs or Sumproduct to accummulate the sales for each within a specified date range.