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
HansVogelaar's avatar
HansVogelaar
MVP
Aug 16, 2022

Arcluna 

If you want to keep the blanks:

 

=IF('REWORKED STYLE MASTER'!P1:P26799="","",'REWORKED STYLE MASTER'!P1:P26799)

 

If you want to suppress the blanks, you can use the FILTER function:

 

=FILTER('REWORKED STYLE MASTER'!P1:P26799,'REWORKED STYLE MASTER'!P1:P26799<>"")

  • Arcluna's avatar
    Arcluna
    Copper Contributor
    Aug 16, 2022
    Thank you so much Hans! So simple... I must be tired...