Generating sequence numbers from cluster values [VLOOKUP to the rescue]
![Generating sequence numbers from cluster values [VLOOKUP to the rescue]](https://chandoo.org/wp/wp-content/uploads/2016/06/generate-squence-numbers-problem.png)
Last night I got an email from Joshua, one of our readers with the subject – Hard Excel problem. Hard?!?, at this stage of summer, the hard problems seem to be (in no particular order),
- Lack of good quality mangoes to eat
- Intense heat and humidity
- Lack of good quality mangoes to eat
Yes, I like mangoes.
Any how, back to Joshua’s email, So I got curios and read it. He is facing a curious problem.
Continue »![Show more of your workbook on screens [quick tip]](https://chandoo.org/wp/wp-content/uploads/2016/05/get-more-screen-space-excel-tip.png)
Ever wanted to show your workbook to someone and felt that you had less screen real estate? This tip will help you get more out of your workbook.
So how to get 50% more space for your workbooks?
Simple, just follow these steps.
Continue »![Fish Eye Effect for highlighting selection – Is it effective? [Advanced Charting]](https://chandoo.org/wp/wp-content/uploads/2016/05/fish-eye-effect-thumb.png)
A few days back, WSJ ran a visualization titled “What’s your pay gap?” It depicts median pay gap between female & male workers in 422 different professions in USA. The chart uses fish eye effect to highlight the selected profession. See below demo to understand the effect.
Continue »
Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.
![SUMPRODUCT – Beginner to Advanced [Master Class]](https://chandoo.org/wp/wp-content/uploads/2016/05/mmc-02-thumb-v3.png)
This is second episode of our Monthly Master Class.
In this one, you will learn all about SUMPRODUCT. Know all about basics to advanced usage of this powerful & versatile formula in this 98 minute master class.
Continue »![How many ‘Friday the 13th’s are in this year? [Formula fun + challenge]](https://chandoo.org/wp/wp-content/uploads/2016/05/friday-13th-in-an-year.png)
Today is Friday the 13th. If you are a raging friggatriskaidekaphobiac, I suggest you to stop reading this post. For the rest of you, I have something fun.
Given a year in cell C3, let’s find out all the months with Friday the 13th. Something like above.
Continue »
Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn…