Creating Scrollable data ranges in Excel - Excel Form Controls: Scroll Bars
If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans! But we humans have another issue and that is we easily get tired of scrolling down especially if the list is so long as if it is […]
10+ ways to SUM Top N values in data range - Ready to be Ben 10 of Excel?
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently discussed how to do conditional SUM as well where we learnt to add up only those values that certain criteria. However, […]
