List Filled Cells in Selected Column

An Excel file that teaches how to perform Listing Full Cells in the Selected Sheet operation.

Excel Spreadsheet for List Filled Cells in Selected Column

The ISLEME function is used to perform a fill test. Array formulas return actual records. Results are printed to an independent range. The original order is preserved. Duplicates are removed optionally.

Hope it is useful.