Forum Discussion

Arcluna's avatar
Arcluna
Copper Contributor
Aug 16, 2022

Linking to a column on another sheet shows thousands of blank rows

Hi there!  I'm new so please pardon me if this is the wrong place to ask this.  I need to link a column on one sheet to another so I simply used the following formula: =IF(ISBLANK('REWORKED S...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 16, 2022

Arcluna 

As variant

=SUBSTITUTE( P1:XLOOKUP(TRUE, P:P<>"",P:P,,,-1), "", "" )