How to enter array formulas in merged cells

Have you ever tried to enter an array formula in merged cells? Then you are familiar with this error message: […]

During 2012 this website had almost 1 200 000 visitors, a 95% increase. It got hit by the google algorithm […]

Convert array formula to a regular formula

Kamran Mumtaz asked: Is there any way to use VLOOKUP for multiple criteria and I do not want to use CSE?; […]

Table of contents Initials from first and last names Initials from first, middle and last names Create middle name initials […]

How to create random numbers, text strings, dates and time values

In excel the RAND() function returns a number greater than or equal to 0 (zero) and less than 1. Combining […]

Sumif across multiple sheets [UDF]

This post describes a basic user defined function that searches multiple ranges and adds corresponding values. […]

Quickly select a range of values in excel

Copying or moving cells is probably one of the most common activities in excel. Here is how to quickly select […]

Find positive and negative amounts that net to zero

I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]

Question: I have a text name coloumn, there will be only 1 value to be listed in 1 coloumn in […]

Create a list of dates with blanks between quarters in excel

Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]

Reverse a list ignoring blanks in excel

Reverse a list ignoring blanks Formula in C2: =INDEX(List, LARGE(IF(List<>"", ROW(List)-MIN(ROW(List))+1, ""), ROWS($C$1:C1))) + CTRL + SHIFT + ENTER copied […]

Sum values containing text based on a condition

Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]