Array formula, copy column to another column ignoring blank

**Confuze** · 06-27-2018, 01:50 PM

Hello,

I'm working with spreadsheet Column A-Z. There's three different table in the sheet. Table 1 Column I, Row (I10: I50) have data includes blank. What I want to do is extract data from column I, Row (I10: I50) to column T Row (T2: T8) without blank.

Thank you in advance

**Bernie Deitrick** · 06-27-2018, 03:34 PM

In T2, array-enter (enter using Ctrl-Shift-Enter) the formula

=IFERROR(INDEX(I:I,SMALL(IF($I$10:$I$50<>"",ROW($I$10:$I$50)),ROW(A1))),"")

and copy down to T3:T8.

**Confuze** · 06-27-2018, 04:30 PM

OMG!!!! thank you very much for your help. You saved me tons of time with your formula.

Array formula, copy column to another column ignoring blank

LinkBack

Thread Tools

Rate This Thread

Display

Array formula, copy column to another column ignoring blank

Re: Array formula, copy column to another column ignoring blank

Re: Array formula, copy column to another column ignoring blank

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to copy a column data in another column, ignoring the blanks

EASYHELP**copy paste value in column to another column, if blank look at another column

Excel 2007 : Copy column of data to new location ignoring blank cells

Ignoring rows with a blank cell in one column

Count how often value changes in a column, ignoring blank cells

[SOLVED] Sorting a text column while ignoring blank cells

Help with ignoring blank cells when drawing a column chart

Bookmarks

Bookmarks

Posting Permissions