Create a numbered list ignoring blank cells
The formula in column B returns a running count based on values in column C.
Formula in cell B3:
The formula consists of two Excel functions. The IF function checks if the corresponding value in column C is not empty.
Cell range $C$3:C3 has one cell that is not empty so the formula returns 1 in cell B3.
Note that cell reference $C$3:C3 expands when you copy cell B3 and paste to cells below.
For example, in cell B4 the cell reference changes to $C$3:C4.
If cell C3 is empty the formula returns nothing.
Download Excel *.xlsx file
How to use absolute and relative references
What is a reference in Excel? Excel has an A1 reference style meaning columns are named letters A to XFD [โฆ]
How to quickly select a non contiguous range
A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell [โฆ]
How to find errors in a worksheet
Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error. [โฆ]
Remove print preview lines (Page Breaks)
Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other [โฆ]
In this article, I am going to show you two ways on how to find blank cells. Both techniques are [โฆ]
A number that is formatted as text will be left-aligned instead of right-aligned, this makes it easier for you to [โฆ]
How to quickly select blank cells
In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of [โฆ]
How to add a macro to your Excel Quick Access Toolbar
The Quick Access Toolbar is located at the very top of your Excel window, I highly recommend that you place your [โฆ]
The picture above shows data in column B, some cells contain nothing, they are blank. I will now go through [โฆ]
How to replace part of formula in all cells
This article explains how to substitute part of a formula across all cells in a worksheet. It is easier than [โฆ]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
English
Spanish
