Vlookup: The syntax for Vlookup is: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Index: The Syntax for Index is: INDEX( array, row_number, [column_number] ) Match: The Syntax for Match is: MATCH( value, array, [match_type] ) Problem:… Read more »
There’s a calculator in Excel 2010 but by default this feature is hidden, to get the calculator on your Excel screen navigate to Quick Access toolbar options, it’s the down… Read more »
A common function many people use is the COUNTIF function and that will count any value you choose. But there isn’t one function to count unique values. But we can… Read more »
For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog. Suppose you have been… Read more »
Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… Read more »
As an Excel or data analyst, dates in datasets are common and usually involve some work to take from raw data stage into meaningful reports. Employee datasets, sales datasets and… Read more »
Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »
There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarize or extract data from poorly structured workbooks. I’m not talking… Read more »
I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so… Read more »
Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’ in the name. Let’s look at an example, say we… Read more »