Way back in 2008, I wrote about using SUMPRODUCT to duplicate the functionality of SUMIFS which was introduced in Microsoft Excel 2007. SUMPRODUCT is a powerful excel function and is more commonly used to multiply two arrays. Let’s first understand the syntax of SUMPRODUCT.
Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.
Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we’ll use VLOOKUP to find a value from the table. Firstly, let’s create the above table in Excel.
Yesterday, we told you how to get your Outlook.com email. Outlook.
Excel has several lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.
First, a short disclaimer: This post merely shows you a method. You alone are entirely responsible for what you use it for. There are times when we need to grab media like images, audio and sometimes even embedded video files from various sites.
One thing that every guy wants to know (besides how to impress a girl) is how to tie a tie and the site 2tieatie.com hopes to answer this question. 2Tie a Tie gets into the history of various knots and teaches you how to tie them.
OnlineProfits.com launched this Monday with $50 off on their monthly price of $98. I decided to signup considering the big names and especially checking out the content they have on offer.
For Dummies is one of the top selling series of books covering tonnes of topics under the sun. It’s usually one of the first purchases for people who want to start afresh anything from business, to computers and the Internet, electronics, finance etc. Now, For Dummies has relaunched Dummies.
A long time ago, I wrote a tutorial on creating custom labels in Microsoft Word. Creating a custom label is necessary only if you don’t plan to use the many inbuilt label templates. The next step after creating a custom label is the actual label merge process.
How fast is your internet connection? If it is as slow as mine and you blog regularly, then you will understand the necessity of doing something to speed up the loading of pages of your WordPress Administration area. Fortunately, WordPress comes inbuilt with this support.
I learnt to play the piano when I was eight and the journey continued until the age of 13, when other priorities took over. Since then I’ve dabbled my way around a keyboard never really taking it up seriously. Hmmm…