Archive for the ‘Misc’ Category
Have you ever tried to enter an array formula in merged cells? Then you are familiar with this error message: […]
Comments(2) Filed in categories: Combine/Merge, Excel, Misc
During 2012 this website had almost 1 200 000 visitors, a 95% increase. It got hit by the google algorithm […]
Comments(5) Filed in categories: Excel, Misc
Table of contents Initials from first and last names Initials from first, middle and last names Create middle name initials […]
Comments(13) Filed in categories: Excel, Misc
In excel the RAND() function returns a number greater than or equal to 0 (zero) and less than 1. Combining […]
Comments(2) Filed in categories: Dates, Excel, Misc
This post describes how to add a new custom-built item to the shortcut menu in excel 2007. In excel 2007 […]
Comments(0) Filed in categories: Misc, VBA
This post describes a basic user defined function that searches multiple ranges and adds corresponding values. […]
Comments(1) Filed in categories: Excel, Misc, User defined functions (udf), VBA
HughMark asks: I have 2 columns named customer (A1) and OR No. (B1). Under customer are names enumerated below them. […]
Comments(3) Filed in categories: Excel, Misc, Vlookup
Copying or moving cells is probably one of the most common activities in excel. Here is how to quickly select […]
Comments(2) Filed in categories: Excel, Misc
I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]
Comments(4) Filed in categories: Count values, Excel, Misc, Solver
Question: I have a text name coloumn, there will be only 1 value to be listed in 1 coloumn in […]
Comments(4) Filed in categories: Excel, Misc
Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]
Comments(6) Filed in categories: Dates, Excel, Misc
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 […]
Comments(0) Filed in categories: Excel, Misc, Sort values
Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]
Comments(1) Filed in categories: Excel, Misc
I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]
Comments(25) Filed in categories: Excel, Misc
Question: How do i get the cell adresses from the cells that contain TRUE? See picture below. Array formula in cell […]
Comments(2) Filed in categories: Excel, Misc
