To get Test Result based on entries in column cells. Sample excel attached.

[pavanbhoyar]

Hello,
I have text data in column. Based on data in column, I want results from the same column.
Sample excel sheet with problem statement and required result is attached.
Looking forward to get required result using excel function.

Thanks in Advance.!

[FDibbins]

Please explain in more detail how you arrive at your expected outcome.

[pavanbhoyar]

Based on the "X" factor. Wherever "X" is appearing, Previous non "X" text should come in result.

[menem]

Please try

G5
=IF(RIGHT(C5,1)<>"x","",INDEX(C$5:C5,AGGREGATE(14,6,--(RIGHT(C$5:C5,1)<>"x")*ROW(C$5:C5),1)-ROW($C$4)))

Regards.

[josephteh]

Try this G5=IF(RIGHT(C5,1)="x",IF(G4="",C4,G4),""), copy down.

[pavanbhoyar]

Thanks a lot.!

Both the solutions worked for me and got desired result.!

[menem]

Try this G5=IF(RIGHT(C5,1)="x",IF(G4="",C4,G4),""), copy down.

Simple and better than mine.

Regards.

[pavanbhoyar]

Yes it is. But your function works fantastic without even being dependent on "G" column.

I have further modified your function to make it work even if the position of "x" is changed from extreme right to any other place in cell.

Modified function :
=IF(ISNUMBER(SEARCH("x",C7)),INDEX($C$7:C7,AGGREGATE(14,6,--(NOT(ISNUMBER(SEARCH("x",$C$7:C7))))*ROW($C$7:C7),1)-ROW($C$6)),"")