How to remove blanks from a list

How to remove blanks from a list

We often find data in a raw, unorganized form that contain empty cells. In this article we’re going to show you how to remove blanks from a list and create a new table using only formulas. Syntax =IFERROR(INDEX(list range,SMALL(IF(ISTEXT(list range),ROW(rows...
A New Dimension Building Excel Models: Array Formulas

A New Dimension Building Excel Models: Array Formulas

Excel’s array formulas are indeed a fascinating subject. Although they can be very useful by making it possible to solve some complex calculations, and replace hundreds of formulas in certain situations, most Excel users have probably never used these formulas before...