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$...
Do you have Excel in Microsoft 365 or Office 2021? If so, enter the following formula in D2:
=FILTER(B2:B11,B2:B11<>"")
The results will automatically spill to the rows below as far as needed.