Forum Discussion
Removing blank lines
I've got a master sheet with data then I'm filtering a column and pulling that information into separate tabs, based on criteria. The master sheet is roughly 1,400 lines long. How do I remove blank...
An additional suggested solution would be to remove or hide the empty lines with a autofilter oder IF Formula,
here a samble with formula :
{=IF(SUMPRODUCT(($A$1:$A$100<>"")*1<ROW(A1),"",INDEX(A:A,SMALL(IF($A$1:$A$100<>"",ROW($1:$100)),ROW(A1))))}
*Contains array formula:
Do not enter the border {},
complete the formula with CTRL + SHIFT + RETURN!
Use AutoFilter to filter your data
https://support.microsoft.com/en-gb/office/use-autofilter-to-filter-your-data-7d87d63e-ebd0-424b-8106-e2ab61133d92?ui=en-us&rs=en-gb&ad=gb
There are many ways that can lead to Rome ... as well as with Excel 🙂
Nikolino
I know I don't know anything (Socrates)