Feb 16 2021 09:13 AM
Using the lookup formula (below) to pull down the header of the last not empty cell. The spreadsheet is linked to another so technically all the cells have formulas in them but not all display values. How do I set it so the formula pulls the header of the last not empty cell, ignoring the formulas/links to the source spreadsheet. I know I've done this in the past but don't remember how ... help!
=LOOKUP(2,1/(T173:V173<>0),T$1:V$1)
Feb 16 2021 10:15 AM