## Self-reference for cell, column and row in worksheet functions

In a worksheet function in Excel, how do you self-reference the cell, column or row you’re in?

Note that this is extremely useful for conditional formatting.

## Have Excel formulas that return 0, make the result blank

A recurring Excel problem I have is formulas such as INDEX(array,row,column) that return 0 when there’s no result, rather than returning blank.

What is the best way to change the zero result to blank?…

## Excel search for cell references in formulas

I inherited a big model and have been trying to reverse engineer some of the formulas. There are a lot of fields. I am not sure if everyone of them is necessary.

Is it possible to search an Excel …

## Conditional median in MS Excel

I’m trying to calculate the conditional median of a chart that looks like this:

A | B
——-
x | 1
x | 1
x | 3
x |
y | 4
z | 5
I’m using MS Excel 2007. I am aware of the AVERAGEIF() …

## Last non-empty cell in a column

Does anyone know the formula to find the value of the last non-empty cell in a column, in Microsoft Excel?

## XIRR Calculation

How do I calculate Excel’s XIRR function using C#?

## How do I get the last character of a string using an Excel function?

How do I get the last character of a string using an Excel function?

## IF statement: how to leave cell blank if condition is false (“” does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE.
Note that, if the following formula is entered in C1 (for which the condition is false) for example:

=…

## How do I only count visible rows when using the COUNTIFS function?

I’ve been using Excel’s COUNTIFS function to count the number of rows in a table that meet certain criteria, E.g: