Need your support in finding a solution for an issue which I am facing now.
Formula for Column A... Data Range from B to D
- Have values in a range of spreadsheet cells (From column B to D)
Value may or may not be present within the range
I need the formula to update the leftmost value from the same row to the Column A.. E.g In Row 2, "Abil" is the leftmost cell from the range B2 to D2.
=Left(B2:D2) which will select the leftmost cell value to the A2 cell