## Archive for Misc

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 […]

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, […]

Text to be on top of column in excel

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 […]

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 […]

Get cell addresses from several cells

Question: How do i get the cell adresses from the cells that contain TRUE? See picture below. Array formula in cell […]