wmfexcel | Work smarter by Mastering Functions in Excel

Why am I so lazy in blogging in the past year?
If you have been following my blog or YouTube channel, you may have noticed I have been inactive for almost a year… don’t worry about me. I am all good!
Just that I’ve got a new role that occupies most of my time and energy. What’s the role? A picture tells a thousand words…...

A decade ago, I wrote a blog post about the same in an no-formula approach. Ten years has past and Excel has evolved so much. With Excel 365, the same task can be performed in an efficient and effective manner by using TEXTJOIN function. See screenshot...

by hiding all unwanted columns and rows
Did you know there are 16384 columns and 1048576 rows on a worksheet? We have the flexibility to navigate any cells within this large range! Nevertheless, this is NOT what we want some time. Think about when you have created a wonderful report or dashboard...

Again, a picture tells a thousand words. The following GIF shows what we want to achieve:
Seriously? A simple VLOOKUP formula stated below would do. What’s the challenge?
Yes, you are right if all these tables reside on the same worksheet. What if they are sitting on different worksheets? or even on different columns?...