Monthly Archives: August 2015

A trick to SUM visible columns only (without VBA)

We know that SUBTOTAL allows us to perform some basics functions like SUM, COUNT, AVERAGE, etc.  that apply to visible rows only.  However, there is no similar function for visible columns only. If we need to SUM visible columns only, we will need … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 4 Comments

Put a dynamic hint for showing or hiding rows or columns hidden by Data Group

This is about using SUBTOTAL and CELL function to detect whether a row and a column is hidden respectively. When rows are hidden by Data–>Group, you will see a +/- button on the leftmost of  spreadsheet to remind you that … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , , | Leave a comment

No Pain No Gain

Learning is a process, in which I believe the easier we take, the less we get. I am glad that I’ve learnt Excel starting with Excel 2000.  Yes it is more than a decade ago. Throughout the decade, I have … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

Convert PDF to Excel without PDF converter

Does it sound familiar? There are many online-converters.  I tried a few of them (freebies) but the result was not satisfactory sometimes.  I don’t blame them as I had managed my expectation.  😛 Without PDF converter, what I tried to do … Continue reading

Rate this:

Posted in General | Tagged | 8 Comments

HLOOKUP – The less-know sibling of VLOOKUP

Many people talk about VLOOKUP and agree that it is one of the most useful functions in their work life with Excel.  However, if you ask them about HLOOKUP, maybe 30% of them have no idea of its existence.  The Google search … Continue reading

Rate this:

Posted in Formula | Tagged | 2 Comments