Forum Discussion
excel problem formula to copy a vertical list but without blanks
windows 20H2 Excel 2108 I have list with some blanks in B2-B12. i want to recreate the list without the blanks in D2-D12. I got this formula from the internet: =IF(ROW()-ROW($B$2:$B$12)+1>ROWS($B$...
In older versions of Excel you can use this array formula confirmed with Ctrl+Shift+Enter, then filled down:
=IFERROR(INDEX($B$2:$B$11,SMALL(IF($B$2:$B$11<>"",ROW($B$2:$B$11)-ROW($B$2)+1,""),ROW(D2)-ROW($D$2)+1)),"")
See the attached version.