Excel Magic Trick 1143

Extract Content From Non-Empty Cells: Filter or Array Formula?

DESCRIPTION

See how to use Filter and Array Formulas to Extract Content From Non-Empty Cells:
(00:39) Filter, Copy, Paste
(01:26) Excel 2010 or later formula with AGGREGATE, INDEX, ROW, ROWS, IF functions in an array formula that DOES NOT require Ctrl + Shift + Enter to put the Array Formula into the cell.
(07:50) Excel 2007 or earlier formula with SMALL, INDEX, ROW, ROWS, IF functions in an array formula that requires the keystrokes Ctrl + Shift + Enter to put the Array Formula into the cell.

WORKBOOKS




Be the first to comment

Leave a Reply