Return the value of cell which is not blank

dinesh.sarsar · Feb 19, 2015

View attachment Non Blank Cell.xlsx

Hi,

I have a file where the data can either be in column A, B, or C and two coloumns will always remain blank.

I want the data of non blank cell in column.

Please help.

NBVC · Feb 19, 2015

In your new column, for example, try:

=LOOKUP(REPT("Z",255),A1:C1)

which will find last text string in A1:C1.

Copy down

dinesh.sarsar · Feb 20, 2015

NBVC said:
In your new column, for example, try:

=LOOKUP(REPT("Z",255),A1:C1)

which will find last text string in A1:C1.

Copy down

thanks buddy that's working

Return the value of cell which is not blank

dinesh.sarsar

New member

NBVC

Super Moderator

dinesh.sarsar

New member