Monthly Archives: May 2015

Date Filter is good, but still with limitation

This is about how to filter a particular date, say 1st of January regardless year, from a list of dates. As a matter of fact, not many people are aware of the Date Filter feature in Excel.  This is true at … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Where are Filter drop-down buttons?

Have you ever encountered a filtered range without Filter drop-down buttons available on the top?  No idea what I am talking about?  Take a look at the following screenshot. Without the Filter buttons on the top, I tried to show hidden … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 15 Comments

Interesting bug – Filter with SUBTOTAL

In the process of writing my previous post, I found something wrong with Filter…  when Column A contains formula starts with SUBTOTAL, Auto Filter refuses to take the last row.

Rate this:

Posted in Excel Tips | Tagged , | 3 Comments

Sequential number for visible rows only

How to display a column of sequential number to visible rows only? Got this question from a friend.  Her task is simple as shown below: I guess many people wanted to achieve the same thing but have no idea at all.  Are … Continue reading

Rate this:

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

Copy data from strictly-protected sheet

How to copy data from a range where you cannot select, due to worksheet protection? Here’s the situation: You receive a worksheet with data but not insight.  Well, it happens and you get use to it already.  You plan to … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 39 Comments