Hi everyone. could someone help me please with a formula? trying to get last non-blank cell in column B then look left to column A and return value of next row down.
so if B20 was last non-blank cell, would like to return value in A21.
TIA.
so if B20 was last non-blank cell, would like to return value in A21.
TIA.